Drill Down Waterfall PRO Visual
Series Configuration

Transcript

All right. So previously we finished off with the toolbar and tooltip settings. In this video, we're going to be going through the series configuration for the waterfall visual.

Now as always, within the sample report, you already have some pre-configured variations of the chart, so you can play around with them. In our case, we're going to be going into the training view and building the chart from scratch so I can go through all the settings one by one.

So as always, first things first, let's create an instance of the waterfall visual. Let's resize it, disable the background and title, and as for the setup, I'm going to be using "type" as my category and I'm going to be using "values for Now, if you go into the formatting options, the way that we have built the waterfall visual is we focus on three types of columns.

So, we have positive changes, negative changes, and a total column. Once you open up either one of them you have additional settings underneath it. So, for example, you can adjust the display name for it. Instead of "positive just say "increase". You can also enable or disable the value labels. Regarding the value labels and their customization, we're going to be talking about more in the next video. So, for the columns what else you can do is you can adjust the width percent. So, you can make the column thicker or narrower, then you can go through line customization, so these lines are actually the connecting lines between the changes.

So, you can adjust the colors, opacities, and also the thickness of those lines, and of course the type. Then afterwards, you have your fill color settings. So, for example, in some cases you know that an increase is not always a good thing. For example, if those are expenses, increase in expenses is actually a bad thing, so you can recolor them through these fills these fill colors. Afterwards, you can also adjust the fill color opacity. So, in cases you want to make the chart a little bit more transparent, you can easily do that.

Now, you do have some additional settings also here, for example, showing legends, showing tooltip and so forth. To actually go through these, I'm going to go up a little bit more and I'm going to enable the legends. Go back to the formatting options for the positive column, and I'm going to showcase you the show in legends first. So, if you disable this, what essentially happens is you remove the legends for that particular series. But if I hover over the columns, you can still see the series and their value is visible. So, it's just one way on how you can work more dynamically with the legends.

Now, the other thing that I can do here is I can also remove it from the tooltip. So, for example, if you do that hovering over the positive changes, it's not going to showcase any value. In certain situations, this might come in handy. Now afterwards, you have your legend markers. We talked about the legend markers in the video regarding the legends and data sorting. Now, next setting right here is going to be "enable column outline".

So, in cases where you actually create a fully transparent column, so let's do it like here, fill color opacity. Let's go for so it's slightly transparent - almost almost transparent. And I'm going to enable the outline, so you can also have variations where you have the outlines but not the filter. And the last two settings you have for all of these three types of series is going to be the connected line series, which allows you to define to which other series is this particular line going to connect. And the other one is the starting point for the line, so by default this is going to be sitting on the edge, but you can also move it. For example, to the center or you can also move it to the full column width.

So, it's something you can play around with and, depending on the use case, adjust it. All right, that's going to be it for the series configuration, and I'll see you in the next video.