All Products
Search

This Product

    Quick BI:Rankings

    Document Center

    Quick BI:Rankings

    Last Updated:Apr 29, 2024

    The ranking reflects the distribution and ranking order of metrics in dimensions, and succinctly displays the ranking of TOP N in descending order. For example, you can use a ranking board to display the top 10 cities that have the largest sales volumes. This topic describes how to create a ranking board and configure the styles of the ranking board.

    Prerequisites

    A dashboard is created. For more information, see Create a dashboard.

    Overview

    • Scenarios

      You can use ranking boards to compare aggregated data from different dimensions and display the rankings.

    • Benefits

      • Easy data analysis: You can obtain the data sum and period-over-period comparison results with a few clicks.

      • Various interactive options: You can add remarks or endnotes to metrics in ranking boards. You can also add links to ranking boards to interact with external systems.

    • Example of a line chart排行榜效果图

    Create a ranking board

    1. On the Data tab, select dimensions and measures based on your business requirements.

      • In the Dimension list, double-click province. You can also drag this dimension to the Category (Dimensions) field.

      • In the measure list, double-click order_number. You can also drag this measure to the Indicator (Measures) field.

      • In the measure list, double-click order_amt, back_point, and profit_amt. You can also drag these measures to the Auxiliary indicators (Mea.) field.

    2. Click Update to create the LBS heat map.

      image.png

    3. Select Auto Refresh.

      After you select Auto Refresh, the system refreshes the ranking board as scheduled. For example, if you select Auto Refresh, enter 5, and then select Minutes, the system refreshes the bubble chart every 5 minutes.

      image.png

    Configure the styles of the ranking board

    The following section describes how to configure the styles of an LBS heat map. For information about the common style settings of charts, see Configure the chart title.

    • In the Metric Data section, you can customize the Style of the chart.

      image.png

      Chart configuration items

      Description

      Set Target Value

      You can customize a data bar. If you do not specify a target value, the data bar displays the percentage of the data that ranks first in the data bar. The percentage of the data that ranks first in the data bar is displayed in the data bar. The percentage of the data that ranks first in other dimensions is displayed in the data bar. If you have set the target value, the proportion of data bars is displayed in the Indicator Value /Target Value format.

      Untitled.gif

      Data Display Mode

      You can select Show All, Data Strip Only, or Number Only.

      Untitled.gif

      Data Display Location

      You can select Data Strip Left or Data Strip Right only if you set Data Display Mode to Show All.

      Note

      Only the Metric /Metric Data location is changed.

      Untitled.gif

      Data bar color

      You can specify Positive Value and Negative Value for Data Strip Color. You can also set Default Display to display several data entries in the leaderboard.

      Note

      The default value is valid only for mobile terminals.

      image.png

      Data Strip Fillet

      You can change the right angle of a data bar to rounded corners.

      Untitled.gif

      Data bar height

      You can customize the data bar height. The peak value is 100%, the valley value is 10%, and the default value is 67%.

      image.png

      Line Spacing

      You can customize the line spacing. The peak value is 30px, the valley value is 0px, and the default value is 6px.

      image.png

      Parallel processing when data is the same

      You can select Rank or Intensive Rank. If you select a ranking method, the data is tied and occupies the ranking. If you select a dense ranking method, the data is tied but does not occupy the ranking. You can also modify the text font and color.

      Untitled.gif

      Default Display on Mobile Terminal

      Custom Settings is supported. Default value: 10.

      image.png

    • In the Column Title section, you can specify whether to display the Column Title and set the Text Style for the column title.

      Untitled.gif

    • You can set custom and TOP3 sort label styles for sort names in Serial Number.

      Untitled.gif

    • In the Conditional Formatting section, configure conditional formats for measures.

      image.png

      Chart configuration items

      Description

      Series

      You can select a measure that you added to the Indicator (Measures) or Auxiliary indicators (Mea.) field.

      Shortcut Style

      Set the icon and font color of the tag from the specified style.

      image

      Custom Style

      Customize the Text and Icon Style, and set the icon, range value, and font color.

      image

      Synchronize Style To

      You can replicate the conditional formatting settings of a measure to other measures.

      Note

      The synchronization style takes effect only once. After you modify the synchronization style, you must synchronize the synchronization again.

    Chart analysis configuration

    Sub-service

    Parameter

    Description

    Data interaction

    Drill

    If you have set the drill-down field in the Fields panel, you can set the drill-level row display style here.

    Linkage

    When the data that you want to analyze belongs to different charts or tables, you can configure this parameter to associate the charts and tables, and then analyze the data. For more information, see the "Configure the filter interaction feature" section in Drilling, filter interaction, and hyperlink.

    Hyperlink

    When the data that you want to analyze belongs to different dashboards, you can configure this parameter to associate the dashboards, and then analyze the data. You can set the Hyperlink parameter to Parameter or External link. For more information, see Configure the hyperlink feature.

    Metric Analysis

    Gridlines

    An auxiliary line can be used to show the difference between the value of a measure and the reference value indicated by the auxiliary line. The reference value can be a fixed value or a calculated value. You can use the following calculated values: average, maximum, minimum, and median. For more information, see the "Auxiliary line" section in Metric analysis.

    Tag the data

    When data in a chart is abnormal or requires extra attention, you can use background colors, icons, remarks, or highlighted data points to mark the data. For more information, see Label.

    Limits

    When you create a ranking board, you must configure the Category (Dimensions), Indicator (Measures), and Auxiliary Indicators (Mea.) fields.

    • You can specify only one dimension for Category (Dimensions), such as area or product_type.

    • You can specify only one measure for Indicator (Measures), such as order_number or profit_amt.

    • You can specify up to three measures for Auxiliary Indicators (Mea.), such as back_point or shipping_cost.

    Important

    By default, 20 entries can be previewed. A maximum of 500 entries can be displayed.

    What to do next

    • You can share your dashboard with others. For more information, see Share a dashboard.

    • If you want to create a navigation menu for thematic analysis, you can integrate your dashboard into a business intelligence (BI) portal. For more information, see Create a BI portal.