topic Re: How to show only fields over 0? in Splunk Search

How to show only fields over 0?

vtsguerrero — Wed, 30 Jul 2014 19:38:56 GMT

I have a query like this:
index=main Product=$product$ | time chart count by Quantity
But I need it to return only values > 0
What should I change here?
Thanks in advance!

Re: How to show only fields over 0?

strive — Wed, 30 Jul 2014 19:40:32 GMT

index=main Product=$product$ | timechart count by Quantity | where count > 0

Updated

The search wont work when the timechart output is like this

_time Quantity1  Quantity2 Quantity3
T1     100        0         120
T2      0         1          1

If you just need quantities where count is greater than zero., then use stats

index=main Product=$product$ | stats count by Quantity | where count > 0

If you want to show timechart and not to show dips when value is zero then do this

index=main Product=$product$ | timechart cont=f count by Quantity

Re: How to show only fields over 0?

flacunsia — Thu, 23 Apr 2015 13:19:22 GMT

cont=f did the trick with timechart... thanks!