Quick BI:Ranking Board

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

Set 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 here.

• 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 data ranking bars displayed on mobile charts. The default is 10.

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 bar for the top-ranked data displays 100%. Data for other dimensions displays as a percentage relative to the top-ranked item. 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

Only when Data Display Method is set to Display All, select from two methods: Left of Data Bar and Right of Data Bar.

Data Bar Color

Set the positive/negative values and background color for data bars. Enable gradient color effects for data bars.

Data Bar Border Radius

Adjust data bars from sharp corners to rounded corners.

Data Bar Height

Customize data bar height. The peak value is 100%, the trough value is 10%, and the default value is 67%.

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

From the styles provided by the system, set the marker icon or font display color for the current measure field.

• Comparison: Select Compare with 0 or Compare with Mean.

• Color Inversion: Taking 'Compare with 0' as an example, less than 0 is red, greater than 0 is green. After inversion, less than 0 becomes green, and greater than 0 becomes red.

• Clear: If you no longer need a set quick style, click Clear to remove it.

Custom Styles

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

• Text: Configure rules to highlight field value text colors, effectively emphasizing key data in the chart visually. 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 specific marker icons in corresponding cells based on numerical comparison results, clearly showing the relationship between current data 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.

Module

Name

Description

Data Interaction

Drilling

After you have configured drill-down fields in the field panel, you can configure the display style for drill-down level rows here. For more information, see Drilling.

Filter Interaction

If the data that you want to analyze exists in different charts, you can configure this feature to associate the charts, and then analyze the data. For more information, see Configure the filter interaction feature.

Go to

If the data that you want to analyze belongs to different dashboards, you can configure dashboard navigation to associate the dashboards for data analytics. Navigation includes Parameter Navigation and External Link. For more information, see Navigation.

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 and Alerting.

Label

When data in a chart is abnormal or requires extra attention, you can use background colors, icons, remarks, or highlighted data points to label the data. This helps you identify abnormalities and take corresponding actions. For more information, see Label.