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 everyone 👋 If you build or maintain Anaplan models, you've probably hit the same walls I kept hitting. Some basic questions about a model's structure have no single screen to answer them. You end up clicking through modules and pages one by one, or writing API scripts just to get a list. These were the gaps that…
Hi Everyone, We have a requirement in Anaplan Consolidation & Reporting (Fluence) where the Entity Structure needs to change effective January 2026. The key requirement is that the existing entity structure should continue to be applicable for all reporting and consolidation periods through December 2025, while the new…
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…
