Splunk Search
Highlighted

How to remove results which are 0 in my timechart search?

Engager

I am trying to find out the index usage per day and getting total usage at the end as well. but if i want to remove all the column from search result which are 0. how to do that?

index=_internal metrics kb group="per_index_thruput" NOT series=_* NOT series="*summary*" host=*appblx*
| eval totalMB = kb /1024
| eval totalGB = round(totalMB /1024, 2)
| timechart useother=f limit=0 span=1d sum(totalGB) as total by series  |addtotals fieldname=TotaldailyUsageinGB
0 Karma
Highlighted

Re: How to remove results which are 0 in my timechart search?

SplunkTrust
SplunkTrust

Depends on what you mean. Are you trying to remove series whose values are zero, or remove dates which have no activity, or what?

0 Karma
Highlighted

Re: How to remove results which are 0 in my timechart search?

Engager

I am trying to remove output columns (series) whose values are 0

0 Karma
Highlighted

Re: How to remove results which are 0 in my timechart search?

SplunkTrust
SplunkTrust

Give this a try

index=_internal metrics kb group="per_index_thruput" NOT series=_* NOT series="*summary*" host=*appblx*
| eval totalGB = round(kb /1024/1024,2)
| bucket span=1d _time
| chart sum(totalGB) as total by _time series limit=0 |addtotals fieldname=TotaldailyUsageinGB

View solution in original post

0 Karma
Highlighted

Re: How to remove results which are 0 in my timechart search?

Engager

Still same.

0 Karma
Highlighted

Re: How to remove results which are 0 in my timechart search?

Engager

below query worked for me , added "where" condition.

index=internal metrics kb group="perindexthruput" NOT series=* NOT series="summary" host=appblx
| eval totalGB = round(kb/1024/1024,2) | where totalGB > 0
| bucket span=1d _time
| chart sum(totalGB) as total by _time series limit=0 |addtotals fieldname=TotaldailyUsageinGB

0 Karma
Highlighted

Re: How to remove results which are 0 in my timechart search?

Motivator

How about this?

 index=_internal metrics kb group="per_index_thruput" NOT series=_* NOT series="*summary*" host=*appblx*
 | eval totalMB = kb /1024
 | eval totalGB = round(totalMB /1024, 2)
 | timechart useother=f limit=0 span=1d sum(totalGB) as total by series  |where total>0|addtotals fieldname=TotaldailyUsageinGB
0 Karma
Highlighted

Re: How to remove results which are 0 in my timechart search?

Engager

thx for the comment .
your query doesn't give result somehow but below query works.

below query worked for me , added "where" condition.

index=internal metrics kb group="perindexthruput" NOT series=* NOT series="summary" host=appblx
| eval totalGB = round(kb/1024/1024,2) | where totalGB > 0
| bucket span=1d _time
| chart sum(totalGB) as total by _time series limit=0 |addtotals fieldname=TotaldailyUsageinGB

0 Karma
Highlighted

Re: How to remove results which are 0 in my timechart search?

Champion

Try this

| index=_internal metrics kb group="per_index_thruput" NOT series=_* NOT series="*summary*" host=*appblx*
| bin _time span=1d
| chart limit=0 eval(round(sum(kb)/1024/1024,2)) by _time series
| foreach * [eval "<<FIELD>>" = if (isnull('<<FIELD>>') OR '<<FIELD>>' = 0, null(), '<<FIELD>>')]
| addtotals fieldname=TotaldailyUsageinGB
0 Karma