Loading

Show Last 6 Or 12 Month Data Based On Parameter Selection

Udgivelsesdato: Apr 13, 2024
Opgave

Show last 6 or 12 month data based on parameter selection

Trin
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
 
Vidensartikelnummer

001453838

Vedhæftede filer

Example.twbx

22 KB

 
Indlæser
Salesforce Help | Article