Forum Discussion

Frequent Visitor

9 years ago

Solved

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?

Anonymous
9 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

Anonymous

Not applicable

9 years ago

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

Zzema
Frequent Visitor
9 years ago
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?
- Anonymous
  Not applicable
  9 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

Related content