Hi Team,
I am using a Parameter to display Date, week or Quarter in my dashboard.
Parameter - ‘Parameter Fiscal Quarter or week or Date’
Filed that I am using to display Date or quarter or week - ‘Date Granularity’
CASE [Parameter Fiscal Quarter or week or Date]
WHEN 'Quarter of Date' THEN [Quarter of Date]
WHEN 'Week of Date' THEN str([Week of Date])
WHEN 'Date' THEN str([Date])
End
Will like to know if there is a way to display last 2 quarters of data only as default view whenever the dashbaord is opened in the server.
Later if the user wants to see the previous quarter/ week or date data then the user should be able to view that based on filter selection.
This is dummy data, the actual data used has quarters starting at different periods hence I used the values for quarter and week too in the dataset.
Attaching the workbook ‘Last 2 qtr default dashbaord’ and Excel data.
Thank you!
Regards,
Rishi Saka
Hi Chris,
I tried a different approach for just the last quarter, wanted to know in which condition the below will not work.
I created a calculated field - Last quarter - "[Quarter of Date] =. {max(Quarter of Date}" and brought it to the filter shelf.
When [Quarter of Date] = No then all the quarters selected in the Date Granularity will show up ,
When [Quarter of Date] = Yes then only the last quarter will show up
When [Quarter of Date] = All then all quarters will show up since the Date Granularity is set to All in the filters.
I have uploaded the workbook "Last Quarter Dashboard" too.
Thank you!
Regards,
Rishi Saka
