Order by and Limit

The Order by and Limit functionality presents your View in Ascending or Descending order and with the selected no. of limit for it.

Check out the given walk-through to understand the Order by and Limit functions for a View.

Steps to perform Order By and Limit on a View using the New UI

The Mixed chart gets selected by default to present the dragged data values.

Select Ascending or Descending order from the context menu with the next click.

Select a measure or dimension value that appears in the context menu on the next click.
Click the Go option to create an instant View.

The View is displayed in the selected order. Here, the selected order is Descending.

Select the Limit option from the context menu and choose a number to limit the View.
Click the Go option.
The View is displayed in the selected order and limit.

Navigate to the Design page.
Click the Switch UI icon to select the old UI option to generate a new View.

Drag and drop a dimension. You may also click twice on Dimensions or Measures to select them.
The selected dimension is displayed in the grid format.

Please Note:

This feature does not work for KPI tiles, Semi Gauge, Maps, Treemap charts, and Metric Summary.
The user can click the Save View icon to save the Views with order and limit to the desired report.

Check out the illustration on using the Manual Sort functionality.

Please Note: The Manual Sort functionality is available under the Old UI interface.

The users can manually sort a view by choosing the customized order they require. They can save the customized order and reuse it whenever needed.

Navigate to the Design Workspace/ Design Canvas.
Choose any combination of one Dimension and Measure to get a graphical display of the View.
By default, the View is displayed in grid format.
Open the Chart Properties window.
Open General Settings fields open.
Navigate to the Order field. By default, the None order option gets selected).
Select the Manual Sort option from the Order drop-down menu.

The Manual Sort window opens.
Select the Create New tab.
Choose a Category from the drop-down menu. Selected Dimension appears here to be selected again.
Enter a title for the Order Name.
Arrange the Values by dragging them up or down to arrange them in the required order. Use the arrows given next to the selected Value to put them at the top or bottom of the list.

Click the Save & Apply option after arranging the fields in the desired order.

Please Note: The Saved tab lists all the saved Orders by the user. Follow the below-given steps to use a saved order.

Please Note: The users also have the option to edit the saved Manual Sort by clicking on the Edit option under the Saved tab.

The user can apply the Order By option based on a hidden Dimension.

The user can use the old UI and drag a dimension value to the specified place for the Hidden dimension.

Select a Dimension from the displayed list of dimensions and measures and drag it to the Hide.

Open the Chart Properties window.
Navigate to the General Settings tab.
Open the Order By options by using the drop-down option.
The selected Hidden dimension appeared in the context menu. E.g., In the following image, the skills option is selected as an Order By option.

Select an order (Ascending or Descending) by using the Order field. the selected option in the following image is Descending.
Select a limit by using the Limit field.