Need help related to custom Time Dimension

Hello Everyone,

Want to create module which captures data days wise, but the challenge is the data should be Displayed in two ways.
So, If current forecast day is 6th Aug, so 1st Column named "Till Date" will be showing Summation of 1st Aug to 5th Aug and remaining days will be displayed in further columns which will sum up to "Remaining days".

Any ideas/suggestions on how to build this ?

Thanks :)

		Forecast
Revnue $	Products	Till Date	8/7/2024	8/8/2024	8/9/2024	8/10/2024	8/11/2024	8/12/2024	8/13/2024	8/14/2024	8/15/2024	8/16/2024	8/17/2024	8/18/2024	8/19/2024	8/20/2024	8/21/2024	8/22/2024	8/23/2024	8/24/2024	8/25/2024	8/26/2024	8/27/2024	8/28/2024	8/29/2024	8/30/2024	8/31/2024	Remaining Days
RevnueUSA	All Products	4.0%	2.0%	2.0%	2.0%	2.0%	2.0%	2.0%	2.0%	2.0%	2.0%	2.0%	2.0%	2.0%	2.0%	2.0%	2.0%	2.0%	2.0%	2.0%	2.0%	2.0%	2.0%	2.0%	2.0%	2.0%	2.0%	50.0%
Revnue China		6.0%	1.0%	1.0%	1.0%	1.0%	1.0%	1.0%	1.0%	1.0%	1.0%	1.0%	1.0%	1.0%	1.0%	1.0%	1.0%	1.0%	1.0%	1.0%	1.0%	1.0%	1.0%	1.0%	1.0%	1.0%	1.0%	25.0%
Revenue APJ		7.00%	8.0%	8.0%	8.0%	8.0%	8.0%	8.0%	8.0%	8.0%	8.0%	8.0%	8.0%	8.0%	8.0%	8.0%	8.0%	8.0%	8.0%	8.0%	8.0%	8.0%	8.0%	8.0%	8.0%	8.0%	8.0%	200.0%

Accepted answers

All comments

seymatas1

Hi @priyanka1029,

Instead of building an Excel-like table at the back end, I built a solution with UX workarounds. Does this work?

priyanka1029

Hello @seymatas1,

In First Grid, r u using Time dimension or line item to capture first 6 days data?

seymatas1

Hi Priyanka,

I am using custom time, months, and days lists, and two subsets.

Revenue% Till Date Module:

Revenue % Forecast Module:

On the UX page, I published only the Revenue % Forecast module's two line items side by side.

I hope this helps.

Seyma 🌷🙂

priyanka1029

Hello @seymatas1,

Thanks for the solution, But not Sure every day current period date will change then previous date data will move from "Remaining days" to "Till Date". In that case how the subset are going to update .ex. Current date is 10/Apr so it's in "Remaining days" subset but tomorrow it will be in "Till Date" subset.

seymatas1

Hi Priyanka,

You can adapt this solution to your model structure. I'm not sure how the rest of your model operates but if you are using a custom day list and you have a concept like "Till Date", you should update the current date and Future Days and Historical Days subsets. You might consider Cloudworks to schedule these actions daily.

Quick Links

Can you help?

Unanswered questions

Dimensionality Issue
Hi ALL, In my model, I have Need stored at a 'D3' RS Group level. I need to use this Need in another module at the G5 Location level. I currently have a mapping module where each G5 Location maps to a D3 RS Group. This Module uses D2 Role as dimension. but the line item I've to find the RS Group (Find D3 RS Group = 'FIND…
Formula to return Connection details...
I couldn't find any formula to do this, but I want a way to put on the page/grid the connection details. This is so I know what connection I'm in rather than going into Connections details to see it. Is there an XL3 formula to return this value?
Postman/Anaplan - message "404, Not found"
Hi all, I, as an Anaplan workspace administrator, am working together with a Fabric team to export data from Anaplan to Fabric via Anaplan API and Postman. We have a problem where all Anaplan exports are visible in Postman but when trying to connect to SOME of them, we get message "404, Not found". Below screenshot showing…