New Pivot Table: Metric Names in Rows

user11861

Is it possible to show the metric names in the rows instead of the columns in the pivot table chart? We currently have to explode the size of our data to get the metric names to appear in the rows and would be great if the new pivot table had this feature.

Matt84096

It sounds like you are describing the collapse (un-pivot) function in Magic ETL. This option will help you turn columns into rows within your dataset. This will increase the row count, but decrease the number of columns. If you want to limit the expansion of your dataset (i.e. rows or records), that will require a deeper assessment of your business requirements to exclude extranneaous data.

 

More information on the collapse function is available here:

https://knowledge.domo.com/Prepare/Magic_Transforms/ETL_DataFlows/02ETL_Actions%3A_Edit_Columns

Matt84096

It sounds like you are describing the collapse (un-pivot) function in Magic ETL. This option will help you turn columns into rows within your dataset. This will increase the row count, but decrease the number of columns. If you want to limit the expansion of your dataset (i.e. rows or records), that will require a deeper assessment of your business requirements to exclude extranneaous data.

 

More information on the collapse function is available here:

https://knowledge.domo.com/Prepare/Magic_Transforms/ETL_DataFlows/02ETL_Actions%3A_Edit_Columns