How can I create a second sheet which is filtered to 8 days ago

Question

Dataset consists of the 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.

Can someone tell me how can I have a second sheet which is filtered 8 days ago, so the same time the previous week?

Answer 1

Following are the steps you can follow:

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"