Loading

Show Last 6 Or 12 Month Data Based On Parameter Selection

Date de publication: Apr 13, 2024
Tâche

Show last 6 or 12 month data based on parameter selection

Étapes
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
 
Numéro d’article de la base de connaissances

001453838

Pièces jointes

Example.twbx

22 KB

 
Chargement
Salesforce Help | Article