About sindhoo

sindhoo · ‎06-20-2018

I have score field which has numeric values from 0-1 ex 0.1,0.2,0.33,0.64 etc, and i have to show the result how many number of scores lie under these ranges 0-0.4 (280) 0.4-0.6 (10) 0.6-0.8 (0) 0.8-1(0) so used rangemap, to set range of score, basic search | rangemap field=score to40=0-0.4 to60=0.4-0.6 to80=0.6-0.8 to1=0.8-1| stats list(range) as r by field1, field2, field3, field4 | stats sum(alerts_count) as "Number Of Alerts Generated", list(facility_alerts) as Facilities list(r) as ranges by tenant, detector,ioi where as in range there are more than 100values but due to its limitation i am only getting 100 values in ranges

sindhoo · ‎06-20-2018

i have values more than hundred and i cant mention max value it can be in thousands or sometimes in millions , i need to divide that value in range by some columns , so i need all values.

sindhoo · ‎06-20-2018

thanks for your response, but it didnt worked, i mentioned fields in last and in both viz and stats only those fields were shown which were in fields command,

sindhoo · ‎06-20-2018

thanks for your response, but it didnt worked, i mentioned fields in last and in both viz and stats only those fields were shown which were in fields command,

sindhoo · ‎06-20-2018

Is there any alternative to list() function as it has limitation to return only 100 values? i have a multivalue list having more than 100 values and repeated, i need all of the values even duplicated. so i cant use list( because it only returns 100 value ) i cant use values(because i need duplicated values ).

sindhoo · ‎06-19-2018

I am also facing same issue, did you find any solution?

sindhoo · ‎06-14-2018

I have created a query which have 4 columns in statistics and want to show column chart as well but with 3 columns. how to remove extra column in statistics? base search | stats total count(a) count(b) by Function Statistics output is --> Function Total count(a) count(b) Test 10 6 4 but in chart i dont want to see column of total, only want to see count of a and b per function but dont want to remove it from statistics.

Posts	7
Solutions	0
Karma Given	1
Karma Received	0
Member Since	‎06-14-2018

Online Status	Offline
Date Last Visited	‎06-05-2020 02:04 AM

Alternative of list(x)

How to remove one field to be shown in column char...

Re: Alternative of list(x)

Re: Alternative of list(x)

Re: How to remove one field to be shown in column ...

Re: How to remove one field to be shown in column ...

Alternative of list(x)

Re: Is there an alternative to the stats list and ...

How to remove one field to be shown in column char...