I am using the TSVB to use filter ratio to divide two values
I need to divide the sum of tcv of just presales stage closed / win with the total tcv
Below is the configuration I used
The filter used in numerator is
Pre-Sales Stage :"Stage 6: Closed Win" OR Pre-Sales Stage : "Stage 6: Won"
The result shows 0 but when i format in percent ,it shows 0.05%
The result is far variated
I should be getting 6.45%
Also the filter used in numerator behaves weird
when I use
Pre-Sales Stage :"Stage 6: Closed Win" the value appears 0%
but if i include 'or' at the end
Pre-Sales Stage :"Stage 6: Closed Win" or ,the values shows 0.05%
I also tried using the query string format...still I get the results far variated.
Please if somebody could help.
Also i am using Kibana 7.6.1
Below is the panel option and option tab settings