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

[sxp5686]

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.

[nickhills]

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