https://community.splunk.com/t5/Splunk-Search/How-to-get-results-for-last-seven-days-and-also-it-follows-below/m-p/359046#M106145 <P>The task is to get total no cases(any cases) for last seven days and display the result like below.<BR /> seven columns each belongs to days of the week and with total cases in each day.</P> Fri, 29 Dec 2017 12:42:31 GMT sxp5686 2017-12-29T12:42:31Z https://community.splunk.com/t5/Splunk-Search/How-to-get-results-for-last-seven-days-and-also-it-follows-below/m-p/359046#M106145 <P>The task is to get total no cases(any cases) for last seven days and display the result like below.<BR /> seven columns each belongs to days of the week and with total cases in each day.</P> Fri, 29 Dec 2017 12:42:31 GMT https://community.splunk.com/t5/Splunk-Search/How-to-get-results-for-last-seven-days-and-also-it-follows-below/m-p/359046#M106145 sxp5686 2017-12-29T12:42:31Z https://community.splunk.com/t5/Splunk-Search/How-to-get-results-for-last-seven-days-and-also-it-follows-below/m-p/359047#M106146 <P>Try something like this:</P> <PRE><CODE>&lt;your search which finds 'cases'&gt; |chart count by date_wday |transpose header_field=date_wday|table monday tuesday wednesday thursday friday saturday sunday </CODE></PRE> <P>and run over 7 days</P> Fri, 29 Dec 2017 13:09:23 GMT https://community.splunk.com/t5/Splunk-Search/How-to-get-results-for-last-seven-days-and-also-it-follows-below/m-p/359047#M106146 nickhills 2017-12-29T13:09:23Z