New Pivot Table: Metric Names in Rows

user11861
user11861 Member
in Charting

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.

Best Answer

  • Matt84096
    Matt84096 Domo Employee
    Answer ✓

    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

Answers

  • Matt84096
    Matt84096 Domo Employee
    Answer ✓

    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

This discussion has been closed.

Categories