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
22 views

1 answer to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
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,470 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
38 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,200 points
43 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,470 points
262 views
0 votes
1 answer

How can I add a row number for a specific field?

Hi @Noob, You can use RANK_DENSE function: "The function returns the ...READ MORE

answered Apr 17, 2018 in Tableau by Atul
• 5,470 points
16 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
286 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
22 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,200 points
226 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
58 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,470 points
367 views
0 votes
1 answer

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.