KNOWLEDGE BASE

Show Last 6 Or 12 Month Data Based On Parameter Selection


Published: 23 Aug 2020
Last Modified Date: 24 Aug 2020

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
 
Did this article resolve the issue?