topic Filter Timechart Fields by Count in Splunk ITSI

Filter Timechart Fields by Count

logankinman99 — Fri, 15 Nov 2019 17:58:38 GMT

So I'm trying to write a query that allows for displaying a timechart after I've filtered fields by count using stats.
I've been able to filter fields by their counts with this...
host=server1 | stats count by errorName | where count > 250
...which does exactly what I want, returning only the errors that have occurred more than 250 times in the given time period.

What I cannot figure out, however, is how to take that and make a visualization out of it. If I change stats to timechart, it does not work. And neither does adding a timechart count after the where clause.
Any ideas would be very helpful!

Thanks,
Logan

Re: Filter Timechart Fields by Count

adonio — Fri, 15 Nov 2019 18:32:40 GMT

| stats ... strips all fields that arent specifically defined either in the functions / attributes section or after the by clause ...
try something like this:

host = server1 | bin _time span=5m | stats count as error_count by errorName _time | where error_count > 250 | timechart span=30m avg(error_count) as avg_error_count by errorName

Re: Filter Timechart Fields by Count

logankinman99 — Fri, 15 Nov 2019 20:12:37 GMT

Hey, this worked pretty well! Thanks!