Forum Discussion
Zzema
9 years agoFrequent Visitor
Work with table (I can't edit visualisation)
Hello, I have this table: But I can't do this table. How I can do this?
- Anonymous9 years ago
Hi Zzema,
I don't think matrix column will support for these values.
In my opinion, I'd like to suggest you click enter to query editor use "unpivot table" function to convert query, then save change and use matrix work on the new table.
Steps:
1. Click on query editor.
2. Right click on current query and choose the reference function.
3. Navigate to referenced query, choose these value column and click on "unpivot table" button.(transform tab -> unpivot table)Regards,
Xiaoxin Sheng