Condition Display in Charts

Version

Application Scenario

When creating charts, you may want to highlight certain special data, for example:

1. Set the maximum and minimum values of a series to different colors.

2. Set the color of columns with the value greater than 0 to red and those smaller than 0 to green.

3. Display the line chart and the column chart in a combination chart with two different colors.

4. Set a flash animation for the last column in a column chart.

In these cases, you have to set condition attributes for charts to meet these special needs. For details about more examples, see section "Index."

Note:

Gauge does not support the condition display.

Procedure

1. Select the chart, choose Special Effect > Condition Display, and click the Add icon to add conditions on the attribute panel.

2. In the condition attribute setting pop-up box, select the attribute to be set.

3. Add conditions. You can use AND or OR to add and combine multiple conditions.

Note:

If you configure an attribute without setting the condition, the attribute will apply to all series or categories in the chart.

The following figure shows the operation steps.

If you add multiple condition attributes, they will be executed from the first one to the last. In the case of conflicts, the latter condition attribute takes precedence.

Attribute

Attributes supported by condition display vary depending on different chart types, generally determined by the style settings available for the chart. For example, the bubble chart has the attribute of bubble while other charts do not.

Taking the column chart as an example, the following chart shows its basic attributes.

Note:

Data Table will only be displayed in Attribute in the condition attribute setting pop-up box when you tick Display Data Table under Style > Data Table of the column chart, line chart, or area chart with a single category axis.

Condition

1. Available Column

When setting condition attributes for charts, available columns will also change with chart types. For example, the following figure shows available columns for column charts.

Among them, Category Index, Category Name, Series Index, and Series Name refer to the categories and series bound to the chart, and Value refers to the corresponding values of the series, as shown in the following figure.

Category Array applies to a multi-category axis and allows you to add conditions for a specific category array. For example, Category Array contains a certain field.

Note:

When Operator is set to Equal to or Not Equal to, the condition must use the formula =ARRAY("Major Category","...","Finest Category").

2. Operator

Operators include Equal to, Not Equal to, Greater than, Greater than/Equal to, Less than, Less than/Equal to, Begin With, Not Begin With, End With, Not End With, Contain, Not Contain, In, and Not In.

3. Available Condition

The following figure shows the available conditions. You can select the corresponding type as needed.

Note:

Only FineReport 11.0.6 and later versions support Summary Field Value. For details about it, see section "Summary Field Value."

Color

When you set the color to transparent in condition attributes, the corresponding graphic fill, chart legends, traction lines, labels will also be displayed as transparent.

For example, when the label character is set to Theme and the label border is set to None by default, if you set Color to Transparent in the condition attribute, the corresponding graphic fill, legend, traction line, label, and label border will all be displayed as transparent, as shown in the following figure.

Opacity

1. For charts with general legends, the setting of opacity in condition attributes takes effect for the colors of graphic fill, legends, and labels, as shown in the following figure.

Note:

For box plots, the setting of opacity in condition attributes only takes effect for graphic fill.

2. For charts with legends displaying data ranges, the setting of opacity only takes effect for the colors of graphic fill, but does not take effect for the legends, as shown in the following figure.

3. If you use Image Fill in charts, the setting of opacity will not take effect, as shown in the following figure.

Unsupported Comparison Between the Value and the Data Column

Value in the available columns is of the int type while Data Column in the dataset is of the array type. You cannot compare them since they specify the containment relationship.

Therefore, you cannot use operators such as Equal to, Less than, and Greater than. You can only use Contain, Not Contain, In, and Not In, as shown in the following figure.

Requirements for the Chart Category in Condition Display

Whether the chart has a single category axis or a multi-category axis, the setting of thecondition display for Category Name only takes effect to the finest category. For a multi-category axis, you can use the setting of Category Array. For details, see the section "Available Column."

Requirements for Condition Display After Setting the Display for Categories and Series

If you set Display when binding the data to charts, you have to use the display value instead of the actual value when setting the condition display, as shown in the following figure.

Requirements for Conditional Attribute Settings in Gantt Charts

When a Gantt chart has multiple projects, to specify a certain subproject, you can add the condition Project Equal to Task A/Function Development, as shown in the following figure.

Summary Field Value

In FineReport 11.0.6 and later versions, the condition option Summary Field Value is added to the chart condition display.

Summary Field Value is only supported in pie charts, column charts, bar charts, line charts, area charts, radar charts, and related charts in combination charts with the chart data source set to Dataset Data.

Note:

In charts that do not support Summary Field Value or with the chart data source set to Cell Data, if you select Summary Field Value, you will find no fields in the drop-down list.

Significance of using Summary Field Value in conditions: You can compare the values of graphics with the summary values of other fields for the same graphics based on a one-to-one mapping relationship between values.

For example, the following figure shows the dataset and condition attributes in Series Value Comparison and Highlighting in a Chart.

The following figure shows the preview effect. The series values of Quality Score of each product are compared with the corresponding  minimum standard scores. For products whose quality scores are lower than the corresponding minimum standard scores, the corresponding columns are highlighted in red.