Hello,
Is there a way I can create a line chart that connects the Actual data and the Forecast?
Attached is the screenshot from Excel that I plan to create in Anaplan.
Thanks,
Tom
Hey @tompatrick.ting ,
You can bring Actuals and Forecast data in one common line item (applying If else condition on Time dimension) and then create a line chart.
However, the line chart won't of 2 different colors as shown in excel.
~ Jitendra
Hello @tompatrick.ting
I have used some rearrangements of line items and tricks to remove trailing zeros and this was the resultant outcome.
The budget trails along, the actual ends and forecast starts at the date of selection. -Sricharan
In one line item bring data of actuals and forecast and then populate the graph it would work for you.
Hello @SriNitya
If one line item is used for continuity purposes, the shift to a different version (color change/show or hide a version, etc.) cannot be observed. Hence multiple line items are used, and conditions are put such that 'NaN' shows up instead of zeroes to avoid erros in graphical representation caused by trailing and leading zeros.
I have 2 lists used in modelling, In Input module I'm using subset of territories from Country List and subset of Regions from Flat list. But in Output module,Its reversed, I'm using subset of regions from Country list and subset of territories from flat list.How to derive the numbers from input to output module. I do have…
This shows all comments across all data to all users with access to the UX page. This is not appropriate for any UX which might contain security access sensitive data. Comments on grids and cards ARE security dependent. That works fine. But anyone with access to the page can open this Summary Panel and see ALL comments…
If anyone is aware of idea exchange ideas that are currently being evaluated by the product team, if you don't mind linking them here, would love to give them an upvote. Thanks!
