How to show monthly, weekly and daily views dynamically in dashboard

[suren946]

How to create a dashboard that allows the user to toggle between monthly, weekly, and daily. More than that, they also wanted to have different date ranges for each of the options: past 30 days for daily view, past 5 weeks for weekly view, and past 10 months for monthly view.

Please suggest.

Regards,

Suren

[andrey_krylov]

Hi, I think you can use "Field Group" for this purpose or  conditional dimensions with buttons to switch between them. For selecting periods can be used trigger.

[suren946]

Hi Andrey,

Thank you for your suggestion but I don't have the Monthly values in my data. So first I have to derive monthly values?

Regards,

Surendra

[boraste-sagar]

use governance dashboard option from QMC

[jonathandienst]

>>allows the user to toggle between monthly, weekly, and daily

Use a cyclic group to switch between the periods. Use the GetCurrentField() function with a single chart to create a dynamic set expression, or define three charts and use GetCurrentField() to control the chart visibility.

>>So first I have to derive monthly values?

If the transactions are at a daily level of detail, then selecting a month will sum the daily values for the month.

[andrey_krylov]

Hi, Surendra. Not necessary, you can replace them with calculated dimensions

=Month(DateField)

=Week(DateField)