Forum Discussion

Zzema's avatar
Zzema
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?
Need Help
Show and Tell
  • Anonymous's avatar
    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

Zzema's avatar
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's avatar
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