All Apps and Add-ons

Range of fields value output


I have events like

user name ,file location, city etc
city value is from 1-10 , what I want to make table that shows no of counts low 1-3, medium 4-6 and high 7-10 by user name , I tried to use case but not working properly and other solution please

0 Karma



<your query> | rangemap field=city low=1-3 medium=4-6 high=7-10 | chart count(range) by username
0 Karma