Kibana show average percentage of average counts

Elastic Stack Kibana
1

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
average1660×407 9.54 KB

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

Many thanks,
Sebastian

2

@Sebastian1, welcome to the forum!
I think Timelion should be able to help you out here. The docs have a fantastic tutorial that walks you through the basics and from there, you'll want to look into the aggregations it supports.
Hopefully that helps!

3

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, to work with? The more information you provide on your post, the better chance you have of getting the answer you wanted.

Thanks,
Nick