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