3

Add total values on top of bars on the Stacked Bar chart


Avatar
Werner Huijboom

Currently, on a Stacked Bar chart, 'Show values' option displays individual total bar values only if 'Dimensions' option is selected for the x-axis.

I would like to be able to see the total values on top of the bars in a Stacked Bar chart, when 'Show values' option is selected along with 'Time series' option for the x-axis (see screenshot).
For example: If for one time period a stacked bar consists of 3 Dimension (10,10 and 10), I would like to see 30 on top of this bar. Therefore, a total per stacked bar per day, week, month etc.
At the moment, only individual values pop-ups when hovering over an individual bar.


A

Activity Newest / Oldest

Avatar

Sandra

Post moved to this board

Avatar

Sandra

Status changed to: Open

Avatar

Werner Huijboom

Hi Sandra,

Thanks for your reply, however this is not what I meant.
What I mean is a total per stacked bar. So, if for one time period a stacked bar consists of 3 Dimension (10,10 and 10), I would like to see 30 on top of this bar. Therefore, a total per stacked bar per day, week, month etc.


Avatar

Sandra

Hi Werner,

Got it, thanks for the clarification.
I believe that this is what you have in mind - see screenshot attached.


Avatar

Werner Huijboom

Hi Sandra,

correct. But as you can see, it does not show the total of all stacked items combined.


  • Avatar
Avatar

Sandra

Hi Werner,

Thanks for your feedback.

Currently, the total value above the Stacked Bar chart is supported in the following scenarios:
- Using Metric without Dimensions (Standard Metric).
Learn more about Standard Metrics here: help.databox.com/article/231-what-is-the-difference-between-attributed-and-standard-metrics#standard.
- Using Metric with Dimensions (Attributed Metric), with x-axis set to 'Dimensions' option (see attached screenshot).
Learn more about Attributed Metrics here: help.databox.com/article/231-what-is-the-difference-between-attributed-and-standard-metrics#attributed.

The total value above the chart (Line and Bar, regardless if stacked or not) is not supported in the following scenarios:
- Using Metric with Dimensions (Attributed Metric), with x-axis set to 'Time series' option
- Using Metric with Dimensions (Attributed Metric) on Line charts

1. Here is an alternative solution on how to overcome this: help.databox.com/article/523-why-the-big-number-is-missing-above-my-chart#attributed.
2. Here is a Roadmap post to upvote on it: roadmap.databox.com/b/chart-improvements/big-number-support-for-metrics-with-dimensions.

Does this help?

Sandra from Databox


Avatar

Sandra

Status changed to: Under review