Day 21 - waterfall chart

As I promised yesterday from today just pure fun. We've finished the block I called advanced and we're going to play around a bit with the types of charts in ThoughtSpot . It's obvious that once you've analysed the data with #SpeedOfThought it's always good to show it in interesting form. We have touched on some of the visualisation in previous days. There was about the column, area and line column charts. But I have left the most interesting visualisations for dessert. In door 21 you will find a waterfall chart.

Waterfall charts are good for visualizing positive and negative growth, and therefore work well with the growth over time keyword.

Let us begin by generating the answer. This will be the quantity presented monthly. By default, a line chart will be generated. Let's change it to a waterfall type.

As you can see, each month is represented by a separate column and each subsequent month begins where the previous month ends. In our case, all the columns have a positive value so they are the same colour. This so you can read the monthly values, but you can see what the cumulative value was in each month.

You can add filters and attributes to the answer. In the attributes case, they will not be used on the chart by default, but in chart option window you can drag them into the Slice with colour field. In this way you will have several series on one chart, which you can compare. I like this way of comparing values.

As it was written in the introduction, the waterfall chart works well for presenting growth. Let's apply it to data generated with the growth command.

Here you see two different colours which correspond to an increase and a decrease. You can observe the cumulative increase and compare monthly values.

The first type of chart is behind us. You have to admit that data presented in this way adds a new perspective to the figures in the table. And tomorrow... I won't say it, you have to come back to open another door.