How to show monthly, weekly and daily views dynamically in dashboard
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.
>>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.
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein