- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How to get results for last seven days and also it follows below mentioned condition?

sxp5686
Explorer
12-29-2017
04:42 AM
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.
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

nickhills
Ultra Champion
12-29-2017
05:09 AM
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!
