Forum Discussion
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
- AlexisOlson
Super User
If you unpivot the three numerical columns on the right, then you can drag and drop the resulting fields into a matrix visual.