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.
Hi Community, I ran into an error while manually importing a CSV file into a module in Anaplan. The error message displayed is: "No current transaction manager" Has anyone experienced this issue before? Thanks in advance for your help!
Hi Anaplan Community, I'm facing an issue while importing data (text details) into a module that has two dimensions: "Unique Line ID" and "Organization x Site". The source file is based on a numbered list. It includes text-formatted columns (line items) that contain the names of the "Unique Line ID" and "Organization x…
Hi, Since last one month we are facing a lot of Integration failures mostly a wake up job is failing (which is a dummy blank action to keep the model alive). We are getting the Error HTTP:429- API request exceeds maximum limit of 600 request per minute. From the process prospective it should not 600 Actions running in a…
