Splunk Search

Time chart with events consist of unique count

iamjosh007
New Member

i have a user login info log file like below for eg, when i prepare a time chart for last 2 days, i need the unique user logged on that particular day on a span of 1 day. there is case where x might have logged in multiple times per day, so dedup would work but that counts for entire span (2 days)..

today
x logged in
y logged in
z logged in

yesterday
x loged in
z logged in

please let me know how can this be achived?

0 Karma

gcusello
SplunkTrust
SplunkTrust

Hi iamjosh007
try something like this

your_search
| timechart dc(user) AS login span=1d

Bye.
Giuseppe

0 Karma
Get Updates on the Splunk Community!

Extending Observability Content to Splunk Cloud

Watch Now!   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to leverage ...

More Control Over Your Monitoring Costs with Archived Metrics!

What if there was a way you could keep all the metrics data you need while saving on storage costs?This is now ...

New in Observability Cloud - Explicit Bucket Histograms

Splunk introduces native support for histograms as a metric data type within Observability Cloud with Explicit ...