Show Last 6 Or 12 Month Data Based On Parameter Selection
Published: 23 Aug 2020 Last Modified Date: 08 Jul 2022
Question
Show last 6 or 12 month data based on parameter selection
Environment
Tableau Desktop
Answer
1. Create a parameter with values 6 and 12
2. Calculation to show last 6 months or 12 months:
if [Choose period] = "6" then if [Date] >= DATEADD('month',-5,datetrunc('month',TODAY())) then "True" END ELSEif [Choose period] = "12" then if [Date] >= DATEADD('month',-11,datetrunc('month',TODAY())) then "True" END END
3. Show the Parameter
4. Drag Month(Date) to view and add the above calculated field to filters and select True
Thank you for providing your feedback on the effectiveness of the article.