Loading

Show Last 6 Or 12 Month Data Based On Parameter Selection

Julkaisupäivä: Apr 13, 2024
Tehtävä

Show last 6 or 12 month data based on parameter selection

Vaiheet
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
 
Knowledge-artikkelin numero

001453838

Liitteet

Example.twbx

22 KB

 
Ladataan
Salesforce Help | Article