The Transpose tool doesn’t change your data, it simply reorganises it. It can help you restructure your data to reduce the need for additional tools.

The Transpose tool to an extent does the reverse of the Pivot tool

The Transpose tool can be very useful before storing your data if you want to use filters/slicers in visualisation tools that select the metric instead of showing all metrics.

​
Configuration

The Tranpose tool consists of two required input.

1

Select Column(s) to Hold Constant

Select the column(s) to hold constant. You can imagine that the columns you select here will remain on rows.

2

Select Columns to Transform to Rows

Select the column you want to transform into columns. You can select as many columns as you need.

As these are transpose you will get a Column and Value column consisting of the selected columns name and corresponding value.

​
When To Use

The Tranpose tool is generally helpful before other calculations:

  • You want to calculate a percentage difference over time (see example below)
  • You want to perform Running Interval calculations
  • You want to calculate similar calculations on multiple columns without duplicating your calculations in multiple Calculate tools
  • You want to prepare your dataset for a visualisation tool where long datasets are preferred over wide datasets
  • It can be helpful before Stacking datasets to ensure consistency in the data

​
Examples