Splunk Search

How to get results for last seven days and also it follows below mentioned condition?

sxp5686
Explorer

The task is to get total no cases(any cases) for last seven days and display the result like below.
seven columns each belongs to days of the week and with total cases in each day.

Tags (2)
0 Karma

nickhills
Ultra Champion

Try something like this:

<your search which finds 'cases'> |chart count by date_wday |transpose header_field=date_wday|table monday tuesday wednesday thursday friday saturday sunday

and run over 7 days

If my comment helps, please give it a thumbs up!
0 Karma
Get Updates on the Splunk Community!

Fueling your curiosity with new Splunk ILT and eLearning courses

At Splunk Education, we’re driven by curiosity—both ours and yours! That’s why we’re committed to delivering ...

Splunk AI Assistant for SPL 1.1.0 | Now Personalized to Your Environment for Greater ...

Splunk AI Assistant for SPL has transformed how users interact with Splunk, making it easier than ever to ...

Unleash Unified Security and Observability with Splunk Cloud Platform

     Now Available on Microsoft AzureOn Demand Now Step boldly into the AI revolution with enhanced security ...