How can I filter my data to see the results for 8 days ago

Question

What I have?

Tableau work sheet with a Measure called 'Cost' and a Dimension called 'Created_date'.

On Sheet 1, I have the 'Cost' filtered by 'Yesterday' which is an option in the filter.

What I want?

I would like to have a second sheet which is filtered 8 days ago, so the same time the previous week?

Answer 1

Hey try these steps and let me know if it helped you: 

1. Create a calculated field using datemath to return a boolean testing if day of created_date = 8 days ago:

   datediff('day',[Created_Date],today())=8

2. Drag this calculation to the filters shelf and filter on "True"