Sorting data
You can select different options to sort data of dimensions and measures in a widget.
On clicking the dimensions or measures in the Included field, you can see the following options to sort data:
If the dimension or measure is from Cloud Data Storage, Proxy or SWG data collections, then you can find the following options:
- A-Z or Z-A - Select the A-Z option to sort data in ascending order. Select the Z-A option to sort data in descending order.
- Delete - Select the Delete option to remove the dimension or measure from the Included field.
If the dimension is from RBI data collections, then you can find the following options:
- Distinct Count - Select the Distinct Count option to include distinct count of dimension in widget.
- Total Count - Select the Total Count option to include total count of dimension in widget.Note: On selecting the Distinct Count or Total Count sorting option, the dimension automatically gets converted to measure.
- A-Z or Z-A - Select the A-Z option to sort data in ascending order. Select the Z-A option to sort data in descending order.
- Delete - Select the Delete option to remove the dimension from the Included field.
- If the measure is from RBI data collections, then you can find the following options:
- Distinct Count - Select the Distinct Count option to include distinct count of measure in widget.
- Total Count - Select the Total Count option to include total count of measure in widget.
- Sum - Select the Sum option to include sum of measure for the selected period in widget. For example, sum of file sizes for the selected period.
- Average - Select the Average option to include average of measure for the selected period in widget. For example, average of file sizes for the selected period.
- A-Z or Z-A - Select the A-Z option to sort data in ascending order. Select the Z-A option to sort data in descending order.
- Delete - Select the Delete option to remove the dimension from the Included field.