I. Overview
1. Application scenarios
For the data in the data table, some data are expected to be classified with fixed units, such as temperature, US dollar, etc., and some data are expected to be set with different colors according to profit and loss. The following is the corresponding results:
2. Idea to acheive
Under Chart > Special Effetcs > Condition Display, add conditional formatting of Data Table.
II. Examples
1. Prepare template
Open designer built in template %fr_Home%/webapps/webroot/WEB-INF/reportlets/doc-EN/Chart/combination/Column-Line_Chart.cpt
2. Set data
Select the chart, click Style > Data Tableon the right, check Display Data Table, select Data Format: Number, and do not modify specific properties:
3. Set condition properties
1) Column chart condition properties
Select the chart, click Special Effects > Condition Display on the right, select the Column chart, add Conditional Formatting, set the attributes as Data Table content, set the Data Format as Number, the character is green with unit mm, and the condition is series index = 1. Click Add to complete the conditional formatting1 editing.
On the right side, click Special effects > Condition display, select the Column chart, add Conditional Formatting, set the attribute as Data Table content, set the Data Format as number, the character is red with unit mm, and the condition is series index = 2. Click Add to complete the Conditional Formatting2 editing.
2) Line condition properties
On the right side, click Special Effects > Condition Display, select line chart and add Conditional Formatting. The attribute is set as Data Table content, Data Format is set as number, the character is blue with unit MB, and the condition is series index = 1. Click Add to complete the Conditional Formatting1 editing.
On the right side, click Special effects > Condition display, select Line chart and add conditional formatting. The attribute is set as Data Table content, Data Format is set as number, and the character is dark blue with unit ℃. The condition is series index = 2. ClickAdd to complete Conditional Formatting2 editing.
4. Effect preview
1) PC terminal
Save the template and click Pagination Preview. The effect is as follows:
2) Mobile terminal
III. Template download
Completed template, see %fr_Home%/webapps/webroot/WEB-INF/reportlets/Doc-EN/Chart/combination/Column-Line_Chart.cpt
Click to download the template:
Previous：Chart Custom Single Series Label
