Order by and Limit

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

• 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.

Creating a View

• Open the Properties tab.

• By default, the None option gets selected for the Order field.

Displaying the Default order

• 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.

Please Note:

• This feature does not work for KPI tile, Semi Gauge, Map, Treemap Chart, and Metric Summary.

• The view-specific Sort By option is provided on the storyboard.

Sort based on Hidden Dimension Value

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 hidden Dimension sorts the View data.

Please Note:

• The hidden Dimension gets applied to the current View without even selecting it from the Order By drop-down.

• The user can also select the hidden Dimension from the Order By drop-down and apply it on the current View.

Manual Sort

Check out the given illustration on the Manual Sort functionality.

Applying Manual Sorting on a View

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.

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

Applying a Saved Manual 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.

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 applies to the current view.