I am trying to return data for a pie chart with a specified range of values. How would I go about this?
| stats count(Score < 5) as "0-4.9" count(Score >=5 AND Score <=8) as "5-8"
Hi
here is link / example how you should do it.
In your case something like
| stats count(eval(Score < 5)) as "0-4.9" count(eval(if(Score >=5 AND Score <=8),1,0)) as "5-8"
r. Ismo
THanks got it to work without the if statement was almost there just didnt think about the eval for that.