KB439600: Showing Total on Dossier Using Waterfall Chart Visualization Displays a Total for Each Attribute Instead of Just the Overall Total

Starting with the release of Strategy ONE (March 2024), dossiers are also known as dashboards.
SYMPTOM:
Using the "Waterfall Chart" visualization from the gallery and turning on totals from the format menu renders total for each category instead of just one for all the category attributes.
STEPS TO REPRODUCE:

1. Download and use the "Waterfall Chart" visualization from the gallery https://community.Strategy.com/s/article/Waterfall-Chart and install.
2. Create a new Dossier.
3. Used dataset "Category Sales Report" from "Strategy Tutorial" project.
4. Select Waterfall Chart from custom section of Gallery (it is under the name "D3Waterfall").
5. Added "Category" to Attribute field and "Revenue" to the Metric field.
6. Click on the format panel tab and select "Visualization Mode" from the first drop down menu. Then select the check box for "Show Totals".

WORKAROUND:
1. Convert the VI to a Grid VI.

2. Right click on the attribute title (in our example Category) and select "Show Totals", "Total"

3. Right click on Total and select "Move to bottom" if it shows up as the first row.

4. Then switch back to the Waterfall VI which will now have a Total section.
 

5. In Visualization Mode, check the option Continuous Mode.This option might be unchecked from Grid to Waterfall.

The result:

Article reference number KB439600