How to display totals on stacked charts (3.42+)


#1

As of Looker 3.42, we have added an option to show totals on stacked column, bar, and area charts. In order to display totals, enable the Totals Labels option the Values section of the visualization menu.

Changing the totals label color

You can change the color of the totals value labels with the Totals Color option. Clicking on the color box will open up the color wheel picker, so you can pick any color you’d like.

Hiding series and showing the totals of hidden series

If you hide some of the series, the totals will automatically display the total for only the visible series:

In order to show the totals for all the series, even if some are hidden, enable the Show Silhouette of Disable Series option. This will show totals for only the enabled series, as well as totals for all series. The disable series will appear greyed out in the visualization:

Changing the density of the totals values

The density of the total labels depends on the value density settings. Lowering the value density will lower the frequency of the totals labels:


Waterfall Charts
Looker 3.42 Release Notes
(Joe Uberuaga) #2

I have a stacked bar graph with totals labels.

However, the position of the total label isn’t uniform on every bar. On half of the bars, it is right above the top of the entire bar, but on the other half, it is on the bottom of the top stack of the bar.

Is there a way to position these labels to be at the top of every bar?


(Desiree) #3

We can’t seem to reproduce this in our sandbox, but usually this type of activity is controlled by the Value Density bar (bottom of the Values tab). Try increasing the Value Density slider all the way to the right and see if that helps. If you still aren’t seeing the type of labeling you’d like, feel free to reach out to support@looker.com.