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 ?
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-
Hi Ian,
Thanks for your answer, the second solution worked perfectly!
regards
Alex