Loading

Show Last 6 Or 12 Month Data Based On Parameter Selection

Data pubblicazione: Apr 13, 2024
Operazione

Show last 6 or 12 month data based on parameter selection

Fasi
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
 
Numero articolo Knowledge

001453838

Allegati

Example.twbx

22 KB

 
Caricamento
Salesforce Help | Article