You can create a date range filter similar like
[your date field] >= dateadd('day',-6, Today())
[your date field] <= Today()
And drag this to filter.
If you can provide a sample workbook will be easier to show the result, otherwise, please try above calculation first.
the date 7 days back from today is datetrunc('day',dateadd('day',-7,today()))
you can make it a filter by comparing date to the value e.g. [date]>=datetrunc('day',dateadd('day',-7,today()))
place on filter shelf and set to true
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
I select true and it returns nothing. I used this [Incident.IncidentDate]>=datetrunc('day',dateadd('day',-7,today()))
Try this blogs.
Also, Please share sample .twbx file for better help.