Order by & Limit

Use the Order By and Limit features to sort View data in ascending/descending order and restrict the number of displayed records.

This functionality helps highlight top or bottom results, reduce clutter, and present data in the most meaningful way.

Prerequisites:

• You are on the Design page (Design canvas).

• The View contains at least one Dimension and one Measure.

• This feature is not supported for:

  • KPI tiles

  • Semi Gauge

  • Maps

  • Treemap charts

  • Metric Summary charts

Order By and Limit (New UI)

1. Navigate to the Design page.

   • By default, the New UI is selected in the Switch UI icon.

2. Create a View

   • Left-click inside the Search bar.

   • Select the required Dimensions and Measures.

   • Click GO.

   • The View is created with a Mixed chart (default).

3. Apply Order By

   • Right-click/Context menu → Order By.

   • Choose Ascending or Descending.

   • Select the Dimension or Measure to sort by.

   • Click GO.

   • The View refreshes in the chosen order.

4. Apply Limit

   • From the context menu, select Limit.

   • Choose the maximum number of records (e.g., 5, 10, 20).

   • Click GO.

   • The View refreshes, showing only the top results based on the selected order.

Order By and Limit (Old UI)

1. Navigate to the Design page.

2. Use the Switch UI icon to select Old UI.

3. Create a View

   • Drag and drop a Dimension into the grid.

   • Drag and drop a Measure (or another Dimension).

   • Open the Charts menu and select Mixed chart.

4. Apply Order and Limit

   • Click the Chart Properties icon.

   • In the Chart Properties window, open General Settings.

   • Configure:

     • Order: None, Ascending, Descending, or Manual Sort.

     • Order By: Select a Dimension or Measure.

     • Limit: Enter the number of rows you want to display.

   • The View refreshes in the selected order and with the applied limit.

Manual Sort (Old UI Only)

Use Manual Sort when you want to define a custom order for category values.

1. On the Design canvas, create a View with at least one Dimension and one Measure.

2. Open Chart Properties → General Settings → Order.

3. Select Manual Sort.

4. Click the Manual Sort icon.

   • The Manual Sort window opens.

5. Select the Category (Dimension field).

6. Enter a name for the custom order.

7. Drag and drop values (or use arrows) to arrange them in the desired sequence.

8. Click Save & Apply.

   • The View updates with the manual order.

9. Saved orders are stored in the Saved tab of the Manual Sort window.

Apply a Saved Manual Order

1. Open the Manual Sort window.

2. Navigate to the Saved tab.

3. Select the saved order from the list.

4. Click Apply.

   • The saved manual sort order is applied to the current View.

5. (Optional) Click Edit to modify an existing saved order.

Hidden By (Order on Hidden Dimension)

You can sort a View based on a hidden dimension, even if it is not displayed in the visualization.

Old UI Workflow

1. Create a View by dragging Dimension(s) and Measure(s) to the grid.

2. Drag the chosen Dimension to the Hide area.

3. Open Chart Properties → General Settings.

4. In Order By, select the hidden dimension.

5. Choose Ascending or Descending order.

6. Enter a Limit if required.

7. The View updates based on the hidden dimension.

New UI Workflow

1. On the Design canvas, select a Dimension + Measure combination.

2. Click GO to create the View.

3. From the next context menu, select hideBy.

4. Choose the hidden dimension.

5. Click GO.

   • The View updates, ordered by the hidden dimension.

Save the Ordered View

• After applying Order By, Limit, or Manual Sort, click Save View.

• A confirmation message ensures the View is saved to the report.