Table Property

Version

Application Scenario

Table Property allows you to use colors or shapes to highlight certain important or abnormal data. For example, you can mark the above-average data in the Contract Amount column with red smiley face markers.

Function Description

You can mark dimension or indicator fields in the table with colors or shapes, as shown in the following figure.

Sample data: Office Supplies Data.xlsx

Upload data to FineBI, and create a group table with the Product Name, Profit, and Sales Amount fields, as shown in the following figure.

Marking the Indicator Data that Meets the Conditions

Sample scenario: Mark the profit data of the top 3 profitable products.

Marking the Top Three Profit Field Values with Colors

1. Drag the Profit field into Table Property > Profit > Color.

2. Perform a Quick Calculation on the Profit field to obtain the ranking of profits in descending order, as shown in the following figure.

3. Set the color based on the sorted profit field. Choose Color > Add Condition, and set the properties for data with a rank ≤ 3, as shown in the following figure.

4. Set colors for the top three values. You can set Text Color and Background Color, as shown in the following figure.

Set Text Color to white, and Background Color to red (cf7536).

5. The following figure shows the effect.

Marking the Top Three Profit Field Values with Shapes

1. Drag the sorted Profit field into Profit > Shape.

2. Choose Shape > Add Condition to mark the first, second, and third places with different colored crown shapes, as shown in the following figure.

Added Conditions Taking Effect for the Summary Data

If Take Effect for Summary Data is selected, the added condition will also take effect for the summary row.

For example, in the following figure, not only the Profit field is involved in the conditional attribute judgment, but also the summary rows of the Classification field are involved. The total profit of furniture ranks first, and the total profits of the consumables and the equipment rank second and third respectively.

Marking Specified Indicators

Sample scenario: Mark the Profit field.

• Use colors to mark the Profit field. Choose Table Property > Profit > Color, and set Text Color to white and Background Color to red (cf7536),  as shown in the following figure.

• Use shapes to mark the Profit field. Choose Table Property > Profit > Shape, as shown in the following figure.

Create a cross table using the Product Name, Area, and Profit fields, as shown in the following figure.

Mark Monitor and North China.

1. Choose Product Name > Color, and set the color condition for the Monitor field, as shown in the following figure.

If no conditions are added, click the color setting button in the yellow area to set the color for all dimension values of the Product Name field.

2. Choose Area > Shape, and set the shape condition for the North China field, as shown in the following figure.

The following figure shows the effect.

Field Setting of Added Indicator Fields

1. The field setting of the indicator fields added in Table Property is consistent with that of the indicator fields in the analysis area. Functions such as Summary Mode, Quick Calculation, and Filter are supported.

2. You can conduct various field-setting operations by clicking the drop-down button next to the Purchase Quantity field and selecting functions from the drop-down list, as shown in the following figure.

Note:

The field setting of an indicator field added in the Table Property area only takes effect on the current indicator field, not the charts.

Dimension Field Setting in the Drill Directory

The Data Drilling function allows you to set each dimension field in the drill directory separately.

For example, the Nation, Province, and City fields in the drill directory need to be set with different shapes. Nation needs to be attached with red circular markers, Province with yellow triangular markers, and City with green smiley face markers.

1. Download the sample data: Data Analysis of Different Areas.xlsx.

2. Create a group table component, and create a drill directory of Nation > Province > City. For details, see Common Drilling.

3. Drag the drill directory Nation > Province > City in the left to-be-analyzed area into Dimension, and drag the Contract Amount field into Indicator, as shown in the following figure.

4. Click Shape under Table Property > Dimension > Nation, click the Add Condition button in the pop-up setting box, and set Nation to be attached with red circular markers, as shown in the following figure.

5. The shape setting of the Province and City fields are the same as that of the Nation field.

6. Effect Preview