Splunk Search

How to plot count of distinct values over time?

monojetski
New Member

How do I count the occurrences of each distinct requestId and plot it over time? First time the requestId was found will be fine for a datetime.

With this search, I can plot count of each distinct requestId vs requestId, but I need it over time, not requestId.

| stats count by requestId

e.g. search result event

2016-02-19 16:49:14,335 INFO  [requestId=c4c6f44b-d28f-4cae-b679-2b1589584a06] [pool-48946-thread-1] 
0 Karma
1 Solution

javiergn
Super Champion

Use chart (or timechart) instead:

| timechart span=1d count by requestId

View solution in original post

0 Karma

javiergn
Super Champion

Use chart (or timechart) instead:

| timechart span=1d count by requestId
0 Karma

monojetski
New Member

Thanks, that was it, then I added | sort - Time .. To sort it by time otherwise it was sorted by the requestId.

0 Karma
Get Updates on the Splunk Community!

More Ways To Control Your Costs With Archived Metrics | Register for Tech Talk

Tuesday, May 14, 2024  |  11AM PT / 2PM ET Register to Attend Join us for this Tech Talk and learn how to ...

.conf24 | Personalize your .conf experience with Learning Paths!

Personalize your .conf24 Experience Learning paths allow you to level up your skill sets and dive deeper ...

Threat Hunting Unlocked: How to Uplevel Your Threat Hunting With the PEAK Framework ...

WATCH NOWAs AI starts tackling low level alerts, it's more critical than ever to uplevel your threat hunting ...