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% |
Answers
-
Hi @priyanka1029,
Instead of building an Excel-like table at the back end, I built a solution with UX workarounds. Does this work?
0 -
Hello @seymatas1,
In First Grid, r u using Time dimension or line item to capture first 6 days data?
0 -
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 🌷🙂
0 -
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.
0 -
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.
0
