Creating a Dimension based on several Measures

Looker Q&A Looker
1

Hi

I have three measures that I want to group into one dimension, where each measure represents one dimensional value. and the actual value of the original measures should all be under a new measure called “count”.

All measures are setup in our table, but I have a hard time creating this setup. anyone know a workaround ?

image.png
image.png380×179 5.76 KB

2

depending on what version you are on you can do this easily with the table next viz: https://docs.looker.com/exploring-data/visualizing-query-results/table-next-options#transpose

if you are not on a supported version then you can do it with some work: https://help.looker.com/hc/en-us/articles/360023862233-Transpose-Table-Display-Measures-as-Rows-

1 Like
3

Hi Ian,

Thanks for your answer, the second solution worked perfectly!

regards
Alex