Cordon/Trendline Setting in the Chart

Version

Application Scenario

Two analysis lines (cordon and trendline) are available in FineBI's charts.. The application scenarios are as follows.

1. Cordon

Cordons are used to give a warning for certain values of indicators (like the contract amount below the average) in the chart, as shown in the following figure.

2. Trendline

Trendlines are used to display the changes in a chart and provide a visual representation of the trend, as shown in the following figure.

Function Description

After the indicator fields are dragged into the horizontal or vertical axis, you can select Set Analysis Line from the drop-down list of the indicator field.

Cordon Adding

You can click Add Cordon to set multiple cordons.

Style Setting

You can set the cordon name, line type, and line color for the cordon.

Value Setting

You can set the value of the cordon by using built-in maximum, minimum, and average values, or by entering values through formulas.

Display Value is ticked by default, indicating that values are displayed at the cordon. You can determine whether to tick the button as needed.

Note:

1. If you set a cordon in the drop-down list of indicator field A, you can only use the indicator field A if you want to use the indicator field for calculation.

2. You can only click values on the left to add formulas

If you want to customize a formula with indicator parameters, you need to manually click Maximum/Minimum/Average on the left to incorporate the parameters.

Cordon Deletion

If you want to delete the cordon, hover your cursor over the setting area, and the delete button will be displayed.

Trendline Adding

You can click Add Trendline to set multiple trendlines.

Style Setting

You can set the trendline name, line type (dashed/solid), and line color for the trendline.

Fitting Method

You can use different fitting methods based on actual data to forecast the development trend of subsequent data. There are four fitting methods for the trendline: Exponential Fitting, Linear Fitting, Logarithmic Fitting, and Polynomial Fitting. 

Cycle Forecast

You can set forecast cycles for trendlines.

Cycle refers to the size of the main scale values on the current horizontal axis. If you push forward or backward n cycles, the corresponding chart will be pushed forward or backward by n scale sizes.

For example, you can set the trendline to push forward and backward 1 cycle respectively. The effect is shown in the following figure.