# Any way to add a Sum Total to a Horizontal Chart?

**URL:** https://discuss.elastic.co/t/any-way-to-add-a-sum-total-to-a-horizontal-chart/193886
**Category:** Kibana
**Created:** [August 5, 2019, 9:35pm UTC](https://discuss.elastic.co/t/any-way-to-add-a-sum-total-to-a-horizontal-chart/193886 "2019-08-05T21:35:10Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![silentfilm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/silentfilm/32/44348_2.png) [@silentfilm](https://discuss.elastic.co/u/silentfilm)
#### Post date: [August 5, 2019, 9:35pm UTC](https://discuss.elastic.co/t/any-way-to-add-a-sum-total-to-a-horizontal-chart/193886/1 "2019-08-05T21:35:10Z")

</div>

I've got a horizontal bar chart visualization that I've built in Kibana as below. The Y-Axis is an aggregation of Count. The Y-Axis is a Split Series of Terms.

 ![horizontal_alarm_severity](https://us1.discourse-cdn.com/elastic/original/3X/b/6/b65497f236224f2618dce49719b4a34a319d6d92.png)

Is there any way to create an extra bar that shows the Sum Total of all three severity levels in one bar?

---

<div class="post-metadata">

### Author: ![wylie](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/wylie/32/81794_2.png) [@wylie](https://discuss.elastic.co/u/wylie)
#### Post date: [August 5, 2019, 10:00pm UTC](https://discuss.elastic.co/t/any-way-to-add-a-sum-total-to-a-horizontal-chart/193886/2 "2019-08-05T22:00:02Z")

</div>

Yes, this is possible using TSVB. TSVB does expect a time bucket, but here is the configuration that worked for me:

The result:

 ![41](https://us1.discourse-cdn.com/elastic/original/3X/4/0/4082a8c05d590415cc887fc036c3902d74d3125e.png)

I used two metrics, one is grouped by Terms, and the other is showing everything. You may want to group using a Lucene or KQL filters instead of Everything, but the principle is the same:

 ![49](https://us1.discourse-cdn.com/elastic/original/3X/7/5/75b353fcce893a2933a4cade9e472c6fcd1c5b28.png)

In the panel options for this setting, I specifically chose "Data timerange mode" -\> "Entire time range" because TSVB would otherwise only look at the most recent bucket. I also customized my index for this visualization.

 ![57](https://us1.discourse-cdn.com/elastic/original/3X/a/7/a7f1e9b08a5b081b52aa80aad0cec1277039edb9.png)

---

<div class="post-metadata">

### Author: ![silentfilm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/silentfilm/32/44348_2.png) [@silentfilm](https://discuss.elastic.co/u/silentfilm)
#### Post date: [August 6, 2019, 3:30pm UTC](https://discuss.elastic.co/t/any-way-to-add-a-sum-total-to-a-horizontal-chart/193886/3 "2019-08-06T15:30:46Z")

</div>

Is the "Data timerange mode" field a 7.x feature? I'm using version 6.7. I also cannot find this field defined in any of the online documentation. It does look like that field would allow the chart to view the entire time-range.

---

<div class="post-metadata">

### Author: ![wylie](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/wylie/32/81794_2.png) [@wylie](https://discuss.elastic.co/u/wylie)
#### Post date: [August 6, 2019, 3:45pm UTC](https://discuss.elastic.co/t/any-way-to-add-a-sum-total-to-a-horizontal-chart/193886/4 "2019-08-06T15:45:54Z")

</div>

You're right, I'm sorry to confuse the issue. This feature isn't released yet, but it has been merged for the upcoming 7.4 release and 8.0 release: [https://github.com/elastic/kibana/pull/37185](https://github.com/elastic/kibana/pull/37185)

---

<div class="post-metadata">

### Author: ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)
#### Post date: [September 3, 2019, 3:46pm UTC](https://discuss.elastic.co/t/any-way-to-add-a-sum-total-to-a-horizontal-chart/193886/5 "2019-09-03T15:46:02Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.