Pivot Chart using Dates for Category Axis

[Victoria@DIG]

I have a pivot chart the uses dates for the category axis. I'd like it to
automatically adjust to show today and the previous 6 days. How would I do
this?

 

[Danny J. Lesandrini]

In the query, add a filter to the date field of ... Date() - 6

 

[Victoria@DIG]

Thanks! I used the following in my date field and it worked great!