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.
Hi @tdr_Dinesh,
It’s been awhile since we last heard from you, did you have any additional questions regarding your post?
If we do not hear back within the next 3 business days, I’ll close out this topic.
Thank you!
Hi @Brett,
Sorry for the delayed response. I have created a sample analysis in Arena and attached the link. It would be greatly helpful if we could get the expected output as shown below. we need to always display the most recent 3 months, followed by rolling 3-month, 6-month, and 12-month data.
Test File -3 analysis
Hi @tdr_Dinesh,
Did you test out what Giri suggested above, and if so, did it not provide the outcome you were looking for?
If not, please try out what was suggested and then you can show us in the Arena view if you encounter any issues!
Thank you
Hi @tdr_Dinesh,
It’s been awhile since we last heard from you. If you’re still in need of further assistance, please test out the suggestions above and let us know what portion did/did not work for your case.
If we do not hear back within the next 3 business days, I’ll close out this topic.
Thank you!
