Create Your First Waterfall
Last updated
Was this helpful?
Last updated
Was this helpful?
After Innofalls Charts and creating a new visual in your report, you are ready to create your first waterfall chart.
To create a waterfall chart, you need to fill at least two fields: Levels and Values. For example, fill in Market into Levels and AC into Values. This already shows a running totals waterfall chart. The chart shows a total bar at the end, summing up all previous data points.
When you add multiple measures into Values, you get a stacked waterfall chart.
To enable drill downs, you have to add two or more dimensions into Levels. This gives you the option to click an element to see how it is made up.
Now, if you click an element in the chart, you will make a drill down into it. In this case we drilled into Energy, to see all underlying Accounts:
The drill down history offers an important ability: We can select additional elements from the previous level to drill down into.
Select another element with a click while holding down the control key (CTRL). The Innofalls visual creates a delta waterfall between the two selected elements, automatically calculating the differences between the two.
You can select any combination of elements in the history, to make the comparisons you need.
Alternatively, you can keep the drill-down history and controls enabled, allowing experienced report viewers to interact with and explore the visual data in greater detail.
The Innofalls Charts offer you a lot of customization options, accessible from the property pane. For example, by default the category width is limited. To disable this, locate the property Limit Category Width under Sizes and Spaces to disable this. In our case this makes our Drill Down History elements wider and more legible.
Now that you created your first waterfall chart, head to the next section to read about all the data fields our visual has to offer.
Note that Innofalls automatically chooses temporal orientation (some say rotation), if you fill in a temporal dimension. You can set a fixed orientation in the menu.
Stacking is the default option for multiple measures. If you prefer to have each measure in a separate waterfall chart, you can do so by choosing a option.
Also note that a plus icon appears next to each category, which enables you to it.
You will notify 4 buttons above the main chart. This is our . It gives us a retrospection on our previous level. Depending on the size of the visual, the drill down history will be shown as a chart (enough space) or as buttons (less space).
At this point, you can finalize the chart in its current form by and , making it ready for your report. This ensures that the report viewer cannot make further modifications to the chart.
