how to add data and configure styles for ranking boards (dashboards)-Quick BI(Quick BI)-阿里云帮助中心

Prerequisites

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

Limits

A ranking board consists of the Category/Dimension, Indicator/Measure, and Auxiliary Indicator/Measure fields:

The category is based on a dimension. Select at most one dimension, such as region or product type.
The indicator is based on a measure. Select at most one measure, such as order quantity or profit amount.
Auxiliary indicators are based on measures. Select at most three measures, such as discount point or shipping cost.

Important

By default, 20 data rows appear in the preview. A maximum of 500 data rows are displayed.

Overview

Scenario

Use ranking boards to compare aggregated data across dimensions and display the rankings.
Benefits
- Easy data analysis: Obtain data sums and period-over-period comparisons with a few clicks.
- Various interactive options: Add remarks or endnotes to metrics, and add links to interact with external systems.
Example Chart

Chart Field Configuration

On the Data tab, select dimensions and measures as needed.
- In the Dimension list, locate Province. Double-click it or drag it to the Category/Dimension area.
- In the Measure list, locate Order Quantity. Double-click it or drag it to the Main Indicator/Measure area.
- In the Measure list, locate Order Amount, Discount Point, and Profit Amount. Drag them sequentially to the Secondary Indicator/Measure area.
Click Update. The chart updates automatically.
auto-refresh

After selecting Auto Refresh, the system refreshes the chart at the specified interval. For example, if you set the interval to 5 minutes, the chart refreshes every 5 minutes.

Chart Style Configuration

Configure chart styling options. For general chart styling configurations, see Configure the chart title.

Basic Styles

In Basic Styles, customize chart styles.

Chart Configuration Item	Configuration Item Description
Row Spacing	Adjust the spacing between ranked rows. The upper limit is 50 px.
Column Width	Adjust the width of each element in the chart. Select Automatic Container Fit or Custom. Automatic Container Fit: The column width automatically adjusts based on the chart container size. Custom: Customize the width of each element in the column.
Parallel Processing for Identical Data	Configure how rankings are handled when data values are the same. Select Rank or Dense Rank. You can also customize the text style of ranked data. Rank: When data values are the same, they are treated as tied and occupy a rank. Dense Rank: When data values are the same, they are treated as tied and do not occupy a rank.
Mobile Default Display	Set the default number of ranking bars displayed on mobile charts. The default is 10.

Data Bars

In Data Bars, set the display style for ranking data bars.

Chart Configuration Item	Configuration Item Description
Set Target Value	Customize data bar target values for Data Bars. If you do not set a target value, the top-ranked item displays 100% and other items display as a percentage relative to it. If you set a target value, the data bar percentage displays as indicator value / target value, as follows:
Data Display Method	Select from three methods: Display All, Data Bars Only, and Numbers Only.
Data Display Position	Available only when Data Display Method is set to Display All. Select Left of Data Bar or Right of Data Bar. Note Only the position of indicator/measure data changes.
Data Bar Color	Set the positive/negative value colors and background color for data bars. You can also enable gradient color effects.
Data Bar Border Radius	Adjust data bars from sharp corners to rounded corners.
Data Bar Height	Customize the data bar height. The maximum is 100%, the minimum is 10%, and the default is 67%.

Column Headings

In the Column Heading section, specify whether to display column headings and configure the name, Top 3 style, and text style.

Ordinal Numbers

In Ordinal Numbers, customize the sort name and the sort label style for TOP 3.

Conditional Formatting

In Conditional Formatting, set conditional formats for measure data.

Chart Configuration Item	Configuration Item Description
Select Field	Select the measure field for which to configure conditional formatting. All measure items are selectable.
Quick Styles	Select a marker icon or font color for the current measure field from the preset styles. Comparison: Select Compare with 0 or Compare with Mean. Color Inversion: For example, with 'Compare with 0', values less than 0 are red and values greater than 0 are green by default. After inversion, the colors are swapped. Clear: To remove a quick style, click Clear.
Custom Styles	You can also configure custom styles for the current measure field as needed. Text: Set rules to highlight field value text colors for visual emphasis. Configure the following information here. Based on Field: Set which data field the conditional rule applies to. This defaults to the field configured in Select Field; you can also select other fields in the chart to configure more complex conditional rules based on their values. Condition Selection: Set the comparison baseline for the conditional rule. Set it to Compare with Static Value or Compare with Dynamic Field. Conditional Rule: Set the specific judgment logic for the conditional rule and the display style for cell text when the rule is met. Configure text color, bold, and italic settings. Add Rule: Click to add a new operation rule. Icon: Display marker icons in cells based on numerical comparison results to show the relationship between current and target data. Configure the following information here. Based on Field: Set which data field the conditional rule applies to. This defaults to the field configured in Select Field; you can also select other fields in the chart to configure more complex conditional rules based on their values. Condition Selection: Set the comparison baseline for the conditional rule. Set it to Compare with Static Value or Compare with Dynamic Field. Conditional Rule: Click the Marker Icon selection box. Select an appropriate icon type from the icon styles provided by the system as needed. Set the specific judgment logic for the data condition corresponding to an icon. You can also select a marker icon individually for each comparison rule. Add Rule: Click to add a new operation rule.
Synchronize Styles To	Synchronize the current conditional format to other measure indicators. Note Style synchronization takes effect only once. Resynchronize after adjusting styles.

Auxiliary Display

In Auxiliary Display, configure the scroll bar display method and thickness.

Tooltip

Hover over a data bar to view its tooltip, which shows the corresponding dimension and measure values.

When a highlight filter interaction is applied, the tooltip of the linked chart also displays the data's original value.

For example, in the following figure, click the North China region on the map. The ranking board highlights the order amount for each product type in North China and displays the original order amount in the tooltip before the filter interaction.

Chart Analysis Configuration

Module	Name	Description
Data Interaction	Drilling	After configuring drill-down fields in the field panel, configure the display style for drill-down level rows here. For more information, see Drilling.
	Filter Interaction	To analyze data across different charts, configure filter interaction to associate them. For more information, see Configure the filter interaction feature.
	Go to	To analyze data across different dashboards, configure dashboard navigation to associate them. Navigation includes Parameter Navigation and External Link. For more information, see Navigation.
Analysis Alert	Auxiliary Line	An auxiliary line shows the difference between a measure value and a reference value. The reference value can be a fixed value or a calculated value such as the average, maximum, minimum, or median. For more information, see Analysis and Alerting.
Label		When chart data is abnormal or requires attention, use background colors, icons, remarks, or highlighted data points to label it. For more information, see Label.

What to do next

When others need to view the dashboard, you can share it with specific people. For more information, see Share a Dashboard.
To create complex dashboards with navigation menus for thematic analysis, integrate your dashboards into the BI portal. For more information, see BI portal.