Hello Team,
We have a requirement to show a visualization as depicted below. We need to display rolling 3-month, 6-month, and 12-month data on the X-axis. Initially, the visualization should show the 3-month data, followed by rolling 3-month, 6-month, and 12-month data. Additionally, we need to set target rates at 4% and 10%, as shown in the snapshot. Any suggestions would be greatly appreciated. Thank you!
Hi @tdr_Dinesh
You can create a calculated field for the legends as follows. (Simplistic view; but using the date functions you could make this dynamic).
I had a simple requirement where I create by group by field like this and then the simple sum measures just fit in properply in the visual. You may need to look at your measure part as i see you have some percentages there.
ifelse(
{Date} >= ‘2024-01-01’ and {Date} <= ‘2024-01-31’, ‘01 - Jan-24’,
{Date} >= ‘2024-02-01’ and {Date} <= ‘2024-02-29’, ‘02 - Feb-24’,
{Date} >= ‘2024-01-01’ and {Date} <= ‘2024-03-31’, ‘03 - Rolling 3’,
{Date} >= ‘2023-10-01’ and {Date} <= ‘2024-03-31’, ‘04 - Rolling 6’,
{Date} >= ‘2023-04-01’ and {Date} <= ‘2024-03-31’, ‘05 - Rolling 12’,
)
The 01, 02 prefix is to have the sorting right.
Hi @Giridhar.Prabhu ,
Thank you, but we need to always display the most recent 3 months, followed by rolling 3-month, 6-month, and 12-month data.
Thanks!
Hi @tdr_Dinesh
If you have the Current Month as a parameter ( or NOW() will do) you should be able to use the addDateTime to get your filter ranges for each calculations and for dynamically displaying Jan/Feb (month names) you can use the FormatDate function.
