Forum Discussion
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?
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
5 Replies
Hi Zzema,
You can simply switch the column field order and turn on the grid to achieve your requirement:
Original Visualmodify the columns orderturn on the grid line
Regards,
Xiaoxin Sheng
Anonymous HI. Very glad to see you answer. But my fields (traffic, orders,revenue etc) is not columns, its a values.
Is this a solvable problem?
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
Anybody now, how decide this problem?
Or maybe someone know, how I can brushed different grids (borders). But change the level of the column name of the date and the name of the fields used is more important
