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?
Br
Bjorn
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:
然后创建瀑布图based on the view created
Hope this helps!
Thanks
Akhtar
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
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
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.
Thanks,
Emily
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;
