This topic describes how to rank the values of grouped metrics. Data ranking facilitates data comparison. When you analyze data, you can view the ranking of measures to make decisions.

Prerequisites

Limits

  • Only cross tables and ranking boards support data ranking.
  • If you rank data in a cross table, make sure that the Pagination feature is disabled. Pagination

Example 1: Rank data in a cross table

  1. Log on to the Quick BI console. In the top navigation bar, click Workspace. In the left-side navigation pane, click Dashboards. On the Dashboards page, click All Items, find the dashboard that you want to manage and click the dashboard name to go to the dashboard editing page.
    The following steps are performed in a workspace of Quick BI Enterprise Standard. Go to the dashboard editing page
  2. In the top navigation bar, click the Cross table icon.
    Cross table of New Version
  3. On the Data tab in the Chart Design pane, configure the parameters for the cross table.
    The dataset used in this example is company_sales_record.
    1. In the Measures list and Dimensions list, find the required fields and double-click or drag them to specific fields.
      • In the Dimensions list, double-click or drag report_date(year) to Rows.
      • In the Measures list, double-click or drag order_amt to Columns.
    2. Click Update.
      A cross table is created, as shown in the following figure. Cross table whose data is not ranked
  4. Click the Style tab and clear Pagination in the Display Settings section.
    Pagination
  5. Click the Data tab. In the Measures list, double-click or drag order_amt to Columns.
  6. In the Columns field, find order_amt(SUM), click the More icon, and then choose Advanced Calculation > Ranking.
    You can set Ranking to Ascend or Descend.
  7. Click Update.
    The following figure shows an example of value ranking for the order_amt field.
    • If you set Ranking to Descend, the order_amt with the largest value ranks No.1.
    • If you set Ranking to Ascend, the order_amt with the largest value ranks No.4.
    Cross table whose data is ranked

Example 2: Rank data in a ranking board

You can set ranking fields in the ranking board to view the rankings in multiple dimensions.

  1. Log on to the Quick BI console. In the top navigation bar, click Workspace. In the left-side navigation pane, click Dashboards. On the Dashboards page, click All Items, find the dashboard that you want to manage and click the dashboard name to go to the dashboard editing page.
    The following steps are performed in a workspace of Quick BI Enterprise Standard. Go to the dashboard editing page
  2. In the top navigation bar, click the icon.
    Ranking Board
  3. On the Data tab in the Chart Design pane, configure the ranking board.
    The dataset used in this example is company_sales_record.
    1. In the Measures list and Dimensions list, find the required fields and double-click or drag them to specific fields.
      • In the Dimensions list, double-click or drag area to Category (Dimensions).
      • In the Measures list, double-click or drag order_number to Indicator (Measures).
      • In the Measures list, drag order_amt to Auxiliary indicators (Mea.).
    2. Click Update. Not ranked
  4. Move the pointer over order_number(SUM) in Indicator (Measures), click the More icon, and then choose Advanced Calculation > Ranking.
    You can set Ranking to Ascend or Descend. In this example, Ranking is set to Descend.
  5. Click Update.
    The following figure shows that values of both order_number and order_amt are ranked in descending order. Ranked