I have documents with different location and types fields.
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.
Is it possible to do that Overall Average in TSVB or in Timelion?