Order by and Limit
Last updated
Last updated
Drag and Drop the desired dimensions and measures to create an instant view.
The Mixed chart gets selected by default to present the dragged data values.
Open the Properties tab.
By default, the None option gets selected for the Order field.
The user gets the following options to display the selected data in a particular order.
None
Ascending
Descending
Manual Sort
The Order By and Limit options get displayed if the selected Order option is either Ascending or Descending.
Order By: Select an option from the drop-down list to set the order of the view (the dragged dimension and measure display in the Order By drop-down list)
Limit: Insert a number to limit the displayed dimension and measured values.
The View gets filtered with the provided order by and limit configurations. E.g., the following View displays 5 records on Sum of salary based on City in the Ascending manner.
The Design workspace contains the Hidden category to drop a Dimension to sort the View Data. The dragged dimension to the Hidden category gets added to the Order By drop-down menu from where the user can use it to order the display of the current view.
Create a View by dragging some Dimension and Measure.
Apply some Order and Sorting using the Order and Order By fields. E.g., for the current image the Order is Descending and the View is Ordered By the Sum of monthly salary.
Drag one Dimension to the Hidden space.
Open the Order By option from the Properties tab.
The dragged Dimension gets listed under the Order By context menu.
The View gets sorted by the hidden Dimension as well.
The users can manually sort a view by choosing the customized order they require. They can save the customized order and reuse it whenever required.
Navigate to the Design workspace/ Story Canvas.
Choose any combination of one Dimension and Measure to get a graphical display of the View.
By default, the None order option gets selected).
Select the Manual Sort option using the Order drop-down icon.
Click the new icon that appears for Manual Sort.
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 required order.
Click the Save & Apply option after arranging the fields in the desired order.
The View columns get displayed in the selected Manual Sort order.
Open the Saved tab from the Manual Sort window.
The dragged Dimension appears in the drop-down menu.
Select a saved order out of the displayed options.
Click the Apply option.
The selected saved manual sort applies to the current view.
​