Dual Dimension Sorting Cheat Sheet

This document describes how dual dimension sorting works within BrightGauge. Dual dimension sorting provides a more granular way to sort data in table, column chart, line chart, and pie chart gauges.
 

Table Gauge

Limit

Always limits the number of rows that appear in the table.

Sort on Measure

Sums the values in each row to get a total for each row. The totals are then used to sort the rows.

Sort on 1st Dimension

Sorts the rows by the 1st column (the 1st dimension).

Sort on 2nd Dimension

Sorts the columns 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

Sorts the columns by column height.

Sort on 1st Dimension

Sorts the columns 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

Sums the values for each x-axis label (1st dimension) to get a total for each label. The totals are then used to sort the x-axis labels.

Sort on 1st Dimension

Sorts the columns 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 the limit is 1, a single 1st dimension value will fill the whole pie.

Sort on Measure

Sums the values for each 1st dimension pie slice to get a total for each. The totals are then used to sort the 1st dimension pie slices clockwise.

Sort on 1st Dimension

Sorts the pie slices 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

Sorts the 2nd dimension pie slices within each 1st dimension slice. 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. 

Was this article helpful?
3 out of 10 found this helpful

Comments

0 comments