Show Last 6 Or 12 Month Data Based On Parameter Selection

KNOWLEDGE BASE

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

User-added image

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