Average of counts in a grouping

Elastic Stack Kibana
1

Hi All,

Is it possible to write below SQL query in Jivana Visualization? Below query works fine with Canvas SQL with display as average.

Select count (a), b, c from "my-index" where x = 'some value' group by b,c

Also I need to calculate the average of counts for all the groupings.

I tried to play around with TSVB, but could not come up with a solution.

Thanks in advance :blush:

2

SQL is not supported in Visualizations but you can configure a visualization to show the same results.

What does your canvas chart look like? Here are some docs for getting started with Kibana visualizations - https://www.elastic.co/guide/en/kibana/current/visualize.html