All Products
Search

This Product

    Quick BI:Ranking Board

    Document Center

    Quick BI:Ranking Board

    Last Updated:Jan 20, 2025

    A ranking board showcases the distribution and ranking of indicators within dimensions, clearly presenting the top N items in descending order. For instance, it can display the top 10 cities by sales. This topic guides you through adding data to a ranking board and configuring its styles.

    Prerequisites

    You have created a dashboard. For more information, see Create a Dashboard.

    Overview

    • Scenarios

      Comparison components are ideal for displaying aggregated data and facilitating the comparison and ranking of results across various dimensions.

    • Advantages

      • Computing power: Easily configure period-over-period and cumulative calculations with a single click.

      • Interactive options: Add comments or endnotes to metrics and include links for external system interactions.

    • Example of Effect Diagram排行榜效果图

    Configure a Ranking Board

    1. On the Data tab, select the required dimension and measure fields:

      • Locate Province in the Dimension list and either double-click or drag it to the Category/Dimension area.

      • Find Order Quantity in the Measure list and double-click or drag it to the Indicator/Measure area.

      • In the Measure list, locate Order Amount, Discount, Point, and Profit Amount, and sequentially drag them to the Auxiliary Indicators/Measures area.

    2. Click Update to automatically refresh the chart.

      image.png

    3. Auto-Refresh

      When enabled, the system refreshes the chart data at set intervals. For instance, setting the duration to 5 minutes will result in the chart being refreshed every 5 minutes.

      image.png

    Configure the Chart Style

    Below are instructions for configuring the chart style. For general chart style settings, refer to Configure the Chart Title.

    • Under Indicator Data, you can customize the chart's Style.

      image.png

      Chart Configuration Item

      Configuration Item Description

      Set Target Value

      Supports custom settings for Data Bars. If you do not set a target value, the data bars will display a 100% proportion based on the data of the top rank, and other dimensions will display proportions based on the first rank. If you set a target value, the Data Bar Proportion will be displayed as Indicator Value/Target Value, as shown below:

      Untitled.gif

      Data Display Method

      Supports three methods: Show All, Data Bars Only, and Numbers Only.

      Untitled.gif

      Data Display Position

      Only when Data Display Method is set to Show All, you can choose between Left of Data Bars and Right of Data Bars.

      Note

      Only the Indicator/Measure Data position changes.

      Untitled.gif

      Data Bar Color

      Supports setting Data Bar Color for Positive Values and Negative Values separately. You can also set the Default Display of several data items in the ranking board.

      Note

      Default Display is only effective on mobile devices.

      image.png

      Data Bar Border Radius

      Supports adjusting the Right Angle of data bars to Border Radius.

      Untitled.gif

      Data Bar Height

      Supports custom modification of Data Bar Height. The peak value is 100%, the valley value is 10%, and the default value is 67%.

      image.png

      Row Spacing

      Supports custom modification of Row Spacing. The peak value is 30px, the valley value is 0px, and the default value is 6px.

      image.png

      Parallel Processing of Identical Data

      Supports two methods: Ranking and Dense Ranking. When the ranking method is selected, data is parallel and occupies a rank. When the dense ranking method is selected, data is parallel but does not occupy a rank. You can also modify the Text Font and Color.

      Untitled.gif

      Default Display on Mobile Devices

      Supports Custom Settings for Display Bars on Mobile Devices. The default is 10 bars.

      image.png

    • In the Column Heading section, you can opt to display the Column Heading and adjust the Text Style.

      Untitled.gif

    • Within Ordinal Number, customize the Sort Name and the style for the TOP3 sort tags.

      Untitled.gif

    • Set up Conditional Formatting for measure data.

      image

      Chart Configuration Item

      Configuration Item Description

      Select Field

      All measure items added to the Indicator/measure or Auxiliary Indicators/measures area can be selected.

      Quick Style

      Set the marker icon or font display color for the current measure field from the styles provided by the system. image

      • Comparison: Supports selecting Compare with 0 or Compare with Average. 112

      • Color Flip: For example, when compared with 0, less than 0 is red, greater than 0 is green. After flipping, less than 0 is green, greater than 0 is red. 112

      • Clear: When a quick style that has been set is no longer needed, click Clear to remove the style. 112

      Custom Style

      In addition to the quick styles provided by the system, you can also configure custom styles for the current measure field as needed.

      • TextimageOn the Text tab, set the conditions for the current measure field text to display as a highlight color. Supports configuring the condition rules for the current field based on the values of other fields.

      • IconimageOn the Icon tab, set the marker rules for the current measure field. Supports configuring the marker rules for the current field based on the values of other fields.

      Sync Style To

      Replicate the conditional formatting settings of a measure to other measures.

      Note

      Sync style is only effective once. You need to sync again after adjusting the style.

    Configure Chart Analysis

    Module

    Name

    Description

    Data Interaction

    Drilling

    When you have set the drilling fields in the field panel, you can set the drilling level row display style here. For more information, see Drilling.

    Filter Interaction

    When the data that you want to analyze belongs to different charts, you can configure this feature to associate the charts, and then analyze the data. For more information, see Filter Interaction.

    Jump

    When the data that you want to analyze belongs to different dashboards, you can configure this feature to associate the dashboards, and then analyze the data. Jump includes Parameter Jump and External Link. For more information, see Jump.

    Analysis Alert

    Auxiliary Line

    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 Analysis Alert.

    Annotation

    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. This helps you detect exceptions and perform subsequent operations. For more information, see Annotation.

    Limits

    The ranking board is comprised of Category/Dimension, Indicator/Measure, and Auxiliary Indicators/Measures:

    • Only one dimension can be specified for Category, such as area or product type.

    • Only one measure can be specified for Indicator, like order number or profit amount.

    • A maximum of three measures can be specified for Auxiliary Indicators, such as back point or shipping cost.

    Important

    By default, the preview displays 20 rows of data, with a maximum of 500 rows possible.

    What to Do next

    • To share the dashboard with specific individuals, see Share a Dashboard.

    • For creating complex dashboards with thematic analysis and navigation menus, integrate the dashboards into the BI portal. For details, see BI Portal.