Hello,
I have a table like this :
id rating_1 rating_2 rating_3
1 0.9 0.5 0.9
2 0.7 0.4 0.8
3 0.7 0.6 0.9
4 0.9 0.5 0.8
I need an histogram of average rating values like that :
__
__ __
__ __
__ __
a __ __ __
v __ __ __
g __ __ __
__ __ __
__ __ __
r1 r2 r3
Is there a way to obtain such a graph in a single question with this kind of data ? Or should I combine multiple questions ?
Thx,
Hi @sfa
Why can't you just use multiple averages? Perhaps I'm misunderstanding something, but you are basically looking for transpose. Filtering tables on columns
Why can't you just use multiple averages?
I use 3 AVG(), the result is on a single row, and in this configuration I can't visualize with histograms
but you are basically looking for transpose
Yes, with 3 rows, 1 AVG result by row, I can visualize the data correctly with histogram.
Is there a way to create a single question with query builder ? (UNION query maybe ?) I need to use filters from dashboard.
My actual fallback solution is to create 3 questions (1 by AVG) and put them in a multi-series card on the dashboard.
Thx a lot !
@sfa You can can still use filters on dashboards with SQL questions:
https://www.metabase.com/learn/sql-questions/sql-variables
https://www.metabase.com/learn/sql-questions/field-filters
