Forum Discussion

ignaciokairuz's avatar
4 years ago
Solved

Hello! Does anyone know how to transform this into this?

 

I'm working with this data from a marketplace.  The 3 values that I'm working with are REVENUE , UNITS and VIEWS . Each one of those for each listing and for each day of a whole week .

 

 

WHAT I HAVE :

 

 

I'm looking forward to get this type of table below. Having in the  first row  the name of each value ( revenue / units / views ), in the second row   the name of the listing and for the next 7 rows the correspondant values for each day of the week .

 

 

WHAT I WANT :

 

 

 

 

I don't care about the order as long as I said before  the  first row  shows the name of each value ( revenue / units / views ), in the second row   the name of the listing and for the next 7 rows the correspondant values for each day of the week .

 

 

Thanks!!

  • If you unpivot the three numerical columns on the right, then you can drag and drop the resulting fields into a matrix visual.

     

     

1 Reply

  • If you unpivot the three numerical columns on the right, then you can drag and drop the resulting fields into a matrix visual.