Sorting data
You can select different options to sort data of dimensions and measures while creating or modifying the 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 a 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 a distinct count of measure in widget.
- Total Count - Select the Total Count option to include the 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 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.