Solved: How to filter results in timechart statistics tabl... - Splunk Community

Getting Data In

EventID = “ok”
| timechart span=1h count(EventID) by Login

Every hour I need to display only those values, where count(EventID)>5

I have used filter command (where) after timechart command but it didnt worked.

Please help me!
Thanks in advance!

1 Solution

Solution

Not a clean solution but this should work

EventID="ok" | bin span=1h _time | stats count(EventID) as cnt by Login _time | where cnt > 500 | timechart span=1h sum(cnt) as cnt by Login| fillnull value=0

View solution in original post

Solution

Not a clean solution but this should work

EventID="ok" | bin span=1h _time | stats count(EventID) as cnt by Login _time | where cnt > 500 | timechart span=1h sum(cnt) as cnt by Login| fillnull value=0

Get Updates on the Splunk Community!

Recap | Agentic Operations Start with Context: Build the Right Data Foundation

Agentic Operations Start with Context: Build the Right Data Foundation By Courtney Wright, Product Marketing ...

Recap | Assisted, Augmented or Agentic? Choose Your Splunk Starting Point

Assisted, Augmented or Agentic? Choose Your Splunk Starting Point By Courtney Wright, Product Marketing ...

Session 2 | Beyond the Thread: Operationalizing AI with Confidence

Session 2 Beyond the Thread: Operationalizing AI with Confidence The true power of the Cisco Data Fabric ...