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 all, I am importing a flat file into ADO. However the flat file does not have a unique identifier. I would like to use the row count as the "ID" Is there a way to create this ADO?
Good morning everyone. I need to build a module export with some specific requirements: users can select a currency type (USD/Local), Salary Type (1 or 2), Nomina Type (1 or 2), and Version (Forecast, TS, Plan). Currently, each of these filters is driven by an independent system module published in the NUX, each…
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…
