Configuring the chart sorting and pagination

For each chart, you can determine the default display order for the chart results and whether to limit the number of results displayed at one time. If the number of results displayed is limited, you can allow end users to page through the chart results.

The chart types have the following sorting options and pagination behavior:

Chart Type Available Items to Sort By How Paging Works
Bar Group dimension value

First metric value

Paging is scrolling left/right (for vertical charts) or up/down (for horizontal charts) to show the previous/next set of bars.
Line/Area Group dimension value

First metric value

Paging is scrolling left/right to see the previous/next portion of the line or shared area.
Bar/Line Group dimension value

First bar metric value

First line metric value

Paging is scrolling left/right to show the previous/next bars and line portions.
Pie Dimension value

Metric value

No paging available.

Users can only use the sort option to see the top or bottom set of values.

Bubble Size metric values

If there is no bubble size metric, then end users cannot change the sort order.

No paging available.

If the number of values displayed is limited, users can only use the sort option to see the top or bottom set of bubbles.

Scatter No sorting available No paging available

To configure the sorting and pagination for a chart:

  1. On the Chart Configuration tab, click Sort options.
  2. From the default sort drop-down list, select the default sort order. The default includes both the item to sort by and whether to sort in ascending or descending order.
    Sorting configuration dialog for a chart with the end user sorting enabled

    Note that for bubble charts, the drop-down list is only enabled if you are limiting the number of bubbles to display. If you do not limit the number of bubbles, then the chart is automatically sorted using the size metric value in descending order.

  3. To allow end users to change the sort order, check the Enable end user sorting checkbox.
  4. To limit the number of results displayed on the chart at a time, check the limit number displayed checkbox.

    If the box is checked, then the remaining pagination settings are enabled.

  5. If you are limiting the number of results displayed at a time, then to not allow users to change the displayed number of items:
    1. Click the Fixed number radio button.
    2. In the field, type the number of results.
  6. To provide a list of options for users to select the number of results to display per page:
    1. Click the Enable end user to change radio button.
    2. In the number of results options field, type a comma-separated list of options.
    3. From the default number of results drop-down list, select the default value to use.
  7. To save the sorting and pagination configuration, click Apply.