# Kibana show average percentage of average counts

**URL:** https://discuss.elastic.co/t/kibana-show-average-percentage-of-average-counts/225587
**Category:** Kibana
**Created:** [March 29, 2020, 8:56pm UTC](https://discuss.elastic.co/t/kibana-show-average-percentage-of-average-counts/225587 "2020-03-29T20:56:36Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![Sebastian1](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/sebastian1/32/48680_2.png) [@Sebastian1](https://discuss.elastic.co/u/Sebastian1)
#### Post date: [March 29, 2020, 8:56pm UTC](https://discuss.elastic.co/t/kibana-show-average-percentage-of-average-counts/225587/1 "2020-03-29T20:56:37Z")

</div>

Hi All,

I have documents with different location and types fields.

**Location;dataType**  
**Loc1;typeA**  
**Loc1;typeA**  
**Loc1;typeB**  
**Loc1;typeB**  
**Loc1;typeB**  
**----**  
**Loc2;typeA**  
**Loc2;typeB**  
**Loc2;typeB**  
**Loc2;typeB**  
**---**  
**Loc3;typeA**  
**Loc3;typeB**

**Loc1 avg : 40%**  
**Loc2 avg : 25%**  
**Loc3 avg : 50%**

Overall avg : 38.33%

Based on the count of TypeA documents, I want to show the Overall Average coming from the average of different location.

Was able to easily do with bar chart and TSVB the average at location level based on filters for DataType and grouping by Location.

 ![average](https://us1.discourse-cdn.com/elastic/original/3X/0/a/0a4b47743318bb09a7145cc6ea6772edba410830.png)

Is it possible to do that Overall Average in TSVB or in Timelion?

Many thanks,  
Sebastian

---

<div class="post-metadata">

### Author: ![cheiligers](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/cheiligers/32/73114_2.png) [@cheiligers](https://discuss.elastic.co/u/cheiligers)
#### Post date: [April 3, 2020, 8:33pm UTC](https://discuss.elastic.co/t/kibana-show-average-percentage-of-average-counts/225587/2 "2020-04-03T20:33:24Z")

</div>

@Sebastian1, welcome to the forum!  
I think Timelion should be able to help you out here. The docs have a [fantastic tutorial](https://www.elastic.co/guide/en/kibana/current/timelion.html) that walks you through the basics and from there, you'll want to look into the aggregations it supports.  
Hopefully that helps!

---

<div class="post-metadata">

### Author: ![nickofthyme](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/nickofthyme/32/60032_2.png) [@nickofthyme](https://discuss.elastic.co/u/nickofthyme)
#### Post date: [April 6, 2020, 2:27pm UTC](https://discuss.elastic.co/t/kibana-show-average-percentage-of-average-counts/225587/3 "2020-04-06T14:27:10Z")

</div>

Hey @Sebastian1!

Are you looking to find the overall count average split by `Loc` and `type` over time? Both TSVB and timelion are time-based visualizations, so I wanted to clarify.

Also could you please send us a sample data set, in [json](https://www.json.org/json-en.html), to work with? The more information you provide on your post, the better chance you have of getting the answer you wanted.

Thanks,  
Nick

---

<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: [May 4, 2020, 2:27pm UTC](https://discuss.elastic.co/t/kibana-show-average-percentage-of-average-counts/225587/4 "2020-05-04T14:27:10Z")

</div>

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