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
Oct 17, 2017, 7:17 PM

Most recent 10 years, how?

I have a date field. I want to filter on this date field for the most recent 10 years. I can find no help on how to use the Filter: Condition: By Forumla capability. No help in the help, that I can find. No examples. Ug

 

I can also find no help for how to use a formula in the Top tab of filter's either.

 

This should not be that hard. Any help is appreciated. There are two filters I might have to use

 

given a date field, where year(thedate) > Year(today)-10

 

Thanks,

 

Allan

4 answers
  1. Deepak Rai
    Oct 17, 2017, 7:30 PM

    (Your Date)>=year(Today)-10 and (Your Date)<=year(Today)

    You can drag it to Filter and Set TRUE

    This should work.

    Thanks

    Deepak

Write an answer...
0/9000