I have a chart shows counts of Policies under different Policy Amount ranges (eg: 10000-50000).
Query:
index|rename Amount as a |eval range = case (a>=10000 and a <= 20000, "10 - 20k" , a>20000 and a <= 50000, "20 - 50k" ,a>50000 and a <= 100000, "50 - 100k" ,a>100000 and a <= 500000, "100 - 500k" ,a>=500000 , ">500k" )| stats count(Policies) by range
It shows y axis data in chart in order as:
10-20k
100-500k
20-50k
50-100k
500k
It is taking ascending order and re ordering.
But I want in the order I defined the ranges, otherwise chart will become irrelevent.
I want it as :
10-20k
20-50k
50-100k
100-500k
500k
... View more