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

0 votes
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?
May 24, 2018 in Tableau by ghost
• 1,790 points
38 views

1 answer to this question.

0 votes

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"

answered Jul 11, 2018 by Atul
• 5,530 points

Related Questions In Tableau

0 votes
1 answer

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

Hey try these steps and let me ...READ MORE

answered Sep 4, 2018 in Tableau by xyz
• 1,550 points
56 views
0 votes
1 answer

How can I filter data to 8 days ago?

Create a calculated field using datemath to ...READ MORE

answered Sep 28, 2018 in Tableau by Atul
• 10,240 points
51 views
0 votes
1 answer

What is pivot in Tableau? how to create a pivot?

HI, When the data required is present in ...READ MORE

answered Jun 12 in Tableau by anonymous
• 26,020 points
27 views
0 votes
0 answers

How to export the IdP (Identity provider) XML Metadata from Keycloak which is imported to Tableau?

Keycloak version 1.6.1, Goal: Keycloak should act ...READ MORE

Mar 28, 2018 in Tableau by Atul
• 5,530 points
429 views
0 votes
1 answer

Reset filters in Tableau

I understood your question (I hope so!). ...READ MORE

answered Mar 29, 2018 in Tableau by QueenBee
• 1,810 points
592 views
0 votes
1 answer

How to create a global filter

Assuming you have created a dashboard already, ...READ MORE

answered Apr 12, 2018 in Tableau by QueenBee
• 1,810 points
49 views
0 votes
1 answer

How to filter/parameter for different date ranges

Steps: Create a parameter control that the users ...READ MORE

answered Jun 20, 2018 in Tableau by Atul
• 10,240 points
718 views
0 votes
2 answers

How can I display filtered value and grand total in the same sheet?

You can create a fixed calculated field ...READ MORE

answered Sep 15, 2018 in Tableau by Machdata
• 340 points
80 views
0 votes
1 answer

How can I use Tableau to create a heatmap?

Step 1: Create an Excel Spreadsheet with ...READ MORE

answered Apr 2, 2018 in Tableau by Atul
• 5,530 points
620 views
0 votes
1 answer