Hi Alacercogitatus, Kindly have a look once get a minute, Thanks. ... View more

Hi Stephane, Kindly have a look once get a minute, Thanks. ... View more

Yes. I have changed the requirement for that. Above search working fine in dashboard panel. If I change the view manually as "Statistics Table", its fine and showing "Memory Currently Under Threshold" for <50 % and showing count (1 or more count/entry) for >=50.Hope i am making sense now. My requirement is to display the results in dashboard panel. If Count > 0, Result display in Line Table (means one or more entries with more than 50%) If Count = 0, Result display in Statistics Table ?? ... View more

Hi Alacercogitatus, Kindly help me to hard code it. I am using below stuffs in my query now. | where memory > 50% | appendpipe [ stats count | eval memory = "Memory Currently Under Threshold" | where count==0 | fields - count ] ... View more

Hi Stephane - Yes. I made a query such that it will display values only if value crosses 50%. Below 50, it wont show anything and it will consider output as zero. My requirement is to display the results in dashboard panel. If Count > 0, Result display in Line Table (means one or more entries with more than 50%) If Count = 0, Result display in Statistics Table ?? ... View more