We recently made an update to improve dual dimension sorting. It's a bit hard to explain so we also put together this little cheat sheet on how Dual Dimension works now with BrightGauge.

**Table Gauge**

- Limit
*Always limits the number of rows that appear in the table.*

- Sort on Measure:
*The values in each row are summed to get a total for each row. The totals are then used to sort the rows.*

- Sort on 1st Dimension:
*The rows are sorted by the 1st column (the 1st dimension).*

- Sort on 2nd Dimension:
*The columns are sorted by the column header (the 2nd dimension). For example, if the 2nd dimension is text, the columns will be sorted alphabetically.*

**Column Chart Gauge**

- Limit
*Always limits the number of columns that appear.*

- Sort on Measure:
*The columns are sorted by column height.*

- Sort on 1st Dimension:
*The columns are sorted by the x-axis label (the 1st dimension). For example, if the 1st dimension is text, the columns will be sorted alphabetically.*

- Sort on 2nd Dimension:
*Easiest to see with the Legend displayed. The multi-color sections within each column are sorted by their label (the 2nd dimension). For example, if the 2nd dimension is text, the multi-color sections in each column will be sorted by the 2nd dimension alphabetically.*

**Line Chart Gauge**

- Limit
*Always limits the number of x-axis labels that appear.*

- Sort on Measure:
*The values for each x-axis label (1st dimension) are summed to get a total for each label. The totals are then used to sort the x-axis labels.*

- Sort on 1st Dimension:
*The columns are sorted by the x-axis label (the 1st dimension). For example, if the 1st dimension is text, the columns will be sorted alphabetically.*

- Sort on 2nd Dimension:
*Does nothing*

**Pie Chart Gauge**

- Limit
*Always limits the number of 1st dimension pie slices that appear. For example, if limit is 1, a single 1st dimension value will fill the whole pie.*

- Sort on Measure:
*The values for each 1st dimension pie slice are summed to get a total for each. The totals are then used to sort the 1st dimension pie slices clockwise.*

- Sort on 1st Dimension:
*The pie slices are sorted by the 1st dimension values. For example, if the 1st dimension is text, the pie slices will be sorted clockwise alphabetically.*

- Sort on 2nd Dimension:
*The 2nd dimension pie slices within each 1st dimension slice are sorted. For example, if the 2nd dimension is text, the 2nd dimension pie slices within each 1st dimension slice will be sorted by the 2nd dimension alphabetically.*

## Comments

0 comments