New Pivot Table: Metric Names in Rows

Reply
White Belt

New Pivot Table: Metric Names in Rows

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.


Accepted Solutions
Purple Belt

Re: New Pivot Table: Metric Names in Rows

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

View solution in original post


All Replies
Purple Belt

Re: New Pivot Table: Metric Names in Rows

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

View solution in original post

Announcements
Check out these great solution videos! The new iSolveditWithDomoboard is live, share yours and earn higher rankings in Dojo click here!