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.
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.
Navigate to the Design page. By default, the New UI gets selected.
Use left-click on the search bar.
A context menu appears.
Select the desired dimensions and measures from the context menu.
Click the Go option to plot the View.
The Mixed chart gets selected by default to present the dragged data values.
Select the Order By option from the context menu.
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.
Drag and drop another dimension or measure as per the requirement of the View.
The selected value is displayed in the grid format.
Click the Charts icon to open the chart's context.
Select the Mixed chart icon.
The View will be displayed in the Mixed chart.
Click the Chart Properties icon.
The Chart Properties window opens.
Navigate to the General Settings properties.
Configure the following fields:
Order: Select an option to select the order for the View data. The user gets the following options to display the selected data in an order:
None
Ascending
Descending
Manual Sort
Order By: Choose a dragged dimension or measure using the drop-down.
Limit: Provide a number to define the limit for the View.
The View will be displayed in the selected order and limit.
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.
Click the Manual Sort icon.
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.
The View columns are displayed in the selected Manual Sort order.
The created Manual Order gets added to the Saved tab.
Please Note: The Saved tab lists all the saved Orders by the user. Follow the below-given steps to use a saved order.
Navigate to the Manual Sort window.
Open the Saved tab.
The dragged Dimension appears in the drop-down menu.
Select a saved order out of the displayed options.
Click the Apply option.
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 selected saved manual sort gets applied to the current view.
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.
Navigate to the Design canvas.
Select a combination of dimensions and measures from the context menu.
A View appears based on the selected Dimension and Measure.
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.
The View gets displayed based on the applied hidden dimension in the set order and limit.
The user can use the next click after selecting a Dimension and Measure combination to create an instant View.
Navigate to the Design canvas.
Select a combination of dimensions and measures from the context menu.
Click the GO option.
A View appears based on the selected Dimension and Measure.
Use the next click to avail of the hideBy option in the context menu.
Use the next click to select the dimension that is to be used as hidden.
Click the GO option.
The View will get ordered by the selected Dimension.
