Waterfall chart NUX

bbolton

Hi,

I want to use the following data to create a waterfall chart:

In the old UX, my waterfall chart includes an end target:

However, in the NUX, the End Total does not appear:

Is there something more I have to do in order to visualize the End Total?

Bjorn

Accepted answers

All comments

Akhtar.shahbaz

Hi @bbolton

In classic model "End Total" will come automatically and we can't hide from the graph but in New UX there is an option whether you want the end total or not.

If order to get the end total just add one more line item in your module and add all the values.

Example:

Then just create the waterfall graph based on the view created

Hope this helps!

Thanks

Akhtar

bbolton

Hi @Akhtar.shahbaz

I would normally do so yes.

However, in this case, the rows are filtered from a list and the line item is the dimension "Value". So I do not think adding another line item will solve it. This is why the end total was helpful.

I have tried to add a new list item (from production list) that could act as end total without success

Akhtar.shahbaz

Hi @bbolton

As you mentioned you have list items in a row based on filter so you can try below approach:

Example:

Below is same as your module, Row having list items

2). Now create a system module with all above list item as line items and mapped accordingly

3). Create another module with all as line item with Total as well.

Now publish above view as waterfall garph.

Hope this helps!

Thanks

Akhtar

njduncanson

Hello!

I'm having a similar issue, however my end total is showing as an increment instead.

I have rows that pull data from other modules as +/- and then the last row simply adds them together, but that end total shows as an increment step up in green.

I cannot find a way to format this or total the details to make it appear as the end result.

Other ideas?

Thanks,

Nancy

njduncanson

@akhtar.shabaz
Hello!

I'm having a similar issue, however my end total is showing as an increment instead.

I have rows that pull data from other modules as +/- and then the last row simply adds them together, but that end total shows as an increment step up in green.

I cannot find a way to format this or total the details to make it appear as the end result.

Other ideas?

Thanks,

Nancy

EmilyS

Hi Nancy,

Is your end total line item marked as "Is Summary"? This checkbox should automatically check itself when you make the simple addition formula.

Summary checkbox.png

Thanks,

Emily

njduncanson

Hi Emily,

Actually, I had found this solution some time ago.

Thanks,

Nancy

ChrisAHeathcote

Hi All,

The data used to populate a waterfall chart must be built up using line items.

Subtotals should be checked as parent items of the line items to be summed and all other dimensions should be set as context selectors and the line items as rows.

If required map your calculations into a staging module using a Line item subset of the target module to set up the mapping module.

I have created an example;

Quick Links

Can you help?

Unanswered questions

Request for Workflow Design: End-User Report Finalization & Stakeholder Notification with Version Co
Hi everyone, I'm looking to design a workflow and would appreciate your input or guidance on how to set this up effectively in Anaplan. So, the goal is: Once end users complete their data input, they should be able to trigger a process that: Notifies stakeholders via email with a link to a report. The report includes: A…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…
Exports with anaplan using informatica connector
I'm trying to execute an Action to export data with the use of a Mapping in Informatica. But it gives us null rows .If we export directly from Anaplan , the export file has all the rows filled. Both exports have same number of rows but in the informatica export the values appear as blank. This issue is with only some…