transformations:pivot
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revision | |||
| transformations:pivot [2025/01/27 11:45] – [Community examples] yurii | transformations:pivot [2025/05/05 17:18] (current) – v5.9.5 updates craigt | ||
|---|---|---|---|
| Line 18: | Line 18: | ||
| |Column labels|Select the column containing the values that will become the column labels of the matrix table (across the top).| | |Column labels|Select the column containing the values that will become the column labels of the matrix table (across the top).| | ||
| |Data|Select the column containing the values that will become the data in the body of the matrix table (at the\\ intersections of the rows and columns). | |Data|Select the column containing the values that will become the data in the body of the matrix table (at the\\ intersections of the rows and columns). | ||
| + | |Aggregate |Check on to aggregate the values in the selected Data column, and choose an aggregation method. \\ Options: //Sum//, //Count//, //Count distinct//, //Min//, //Max//, //Any//, or // | ||
| |Preserve formatting|Select this option when a column of date/time values will be used for column headers to retain the date/time format. | |Preserve formatting|Select this option when a column of date/time values will be used for column headers to retain the date/time format. | ||
| + | |Column order|Choose whether the resultant columns retain their order or are sorted. | ||
| \\ | \\ | ||
transformations/pivot.txt · Last modified: 2025/05/05 17:18 by craigt