Skip to main content
Topics#Tableau Desktop & Web AuthoringTableau Community Forums Member (Inactive)'s Question
Tableau Community Forums Member (Inactive) (Salesforce) asked in #Tableau Desktop & Web Authoring
Sep 18, 2020, 4:50 AM

Relative Date Filter

Hi,

I have a dimension Date, If i want to use date filter 

Filter 1 - Last 7 days

        Last 30 days

        MTD etc

        Custom

Filter 2-Previous Period

        Previous period last year

        Custom

I want to use Filter 1 and Filter 2 at the same time means if i select last 7 days in filter 1 then i can select previous period in Filter 2

Is there any solution for this?

Thanks,

 

  •  
1 answer
  1. Jim Dehner - Tableau Visionary HoF (Market Analytics LLC)
    Sep 18, 2020, 2:14 PM

    good morning @Shubhangi Jaiswal​ 

    Filters remove data from the data set for the worksheet so when you filter for the last 7 days no other data remains

    you can set the date with a parameter and use lods to get the values you want see the second solution on https://jimdehner2.blogspot.com/2019/12/yoy-three-different-approaches.html and use a dynamic parameter to update to the latest date when the workbook is opened see https://jimdehner2.blogspot.com/2020/03/parameters-and-parameter-actions.html

     

    If this posts assists in resolving the question, please mark it as “Best Answer” or Upvote. 

    Also please help use better track your reply by including a mention to the volunteer who provided the answer  – mine is   @[Jim Dehner]​ 

    Thank you.

    Jim

Write an answer...
0/9000