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.
When importing data from a Data Hub to another model, I'm seeing values in the target model that don't exist in the source. For example, seller assignments are being tagged with subregions that aren't present in the source data - some assignments are missing expected tags, while others are mapped to seemingly random…
Hi, I need help in pulling a specific view in Anaplan XL. The first grid should display attributes of various projects, while the second grid should present the monthly financial data for these projects. Thanks in advance.
Hi, I am working on a solution where the User should only have access to write/edit the list members that they add from an Action on the frontend. This action adds another list member to a selective access list. The problem is, in order to run the action, you need access to the entire list, so you would see all list…
