You can interact with a Pivot in LityxIQ as it is being displayed.
- Analysis Style. Select between different pre-designed pivot table structures.
- Selecting Table is the most common, as it provides a multi-dimensional cross-tabulation of the dataset.
- Other options provide the same data, but viewed in other fashions such as heat maps and charts.
- The CSV Export option will list the data in a comma-separated format that you can copy/paste into other applications.
- Aggregation type.
- Count is the default aggregation in the pivot. This method will show the count of records for each cell in the pivot table.
- Any other selected aggregation type will make available an additional drop down box to select a metric. For example, if you select Average, you will then choose the metric for which to show averages within each cell of the pivot.
- Metrics
- This option appears when Aggregation Type is set to anything other than Count. The metrics appearing here will be the ones you defined when creating the Pivot.
- Dimensions. Drag and drop horizontal and vertical dimensions to and from the Unused Dimensions box, and drag dimensions within the boxes to re-order them in the pivot. You can also click the arrow next to the dimension name to filter on specific values of each dimension.