This topic describes the auxiliary line and trend line analysis methods.
Background information
Analysis and warning allows you to analyze the current data from multiple perspectives. You can use this feature to intuitively understand data trends and anomalies.
Analysis and warning currently supports two analysis methods: auxiliary line and trend line.
Limits
The following table lists charts that support these analysis methods.
Chart name | Gridlines | Trendline |
Line Chart | ✓ | ✓ |
Area chart | ✓ | ✓ |
Stacked area chart | Supported | × |
100% stacked area chart | Supported | × |
configure a vertical bar chart | ✓ | ✓ |
Stacked vertical bar chart | Supported | × |
100% stacked vertical bar chart | Supported | × |
bar-chart-for-DataV-6-0 | ✓ | ✓ |
Stacked horizontal bar chart | Supported | × |
100% stacked horizontal bar chart | Supported | × |
configure a combination chart | ✓ | ✓ |
Indicator trend chart | × | × |
Scatter plot | Supported | × |
Display query results on a bubble chart | Supported | × |
Rankings | Supported | × |
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 setting value of auxiliary line is divided into three types: static field value, calculated value and custom value.
After you log on to the Quick BI console.
On the Dashboards page, find the dashboard that you want to edit and click the
icon. On the dashboard editing page, click the chart whose labels you want to edit.
On the Advanced tab of the Data panel, click the
icon next to Analysis Alert > Auxiliary Line. On the Auxiliary Line page, select the type of the setting value of the auxiliary line, including static field, calculated value and custom.
You can select Average Value, Maximum Value, Minimum Value, or Median for Calculated Value.
Custom allows you to reference fields and functions for custom computing.
Click OK. The following figure shows a sample auxiliary line.
Trendline
A trendline displays the overall trend of the data that you selected. Quick BI provides the following types of trendlines: Intelligent, Linear, Logarithmic, Exponential, Polynomial, and Power.
On the Dashboards page, find the dashboard that you want to edit and click the
icon. On the dashboard editing page, click the chart whose labels you want to edit.
On the Advanced tab of the Data panel, click the
icon to the right of Analysis > Trend Line. On the Trendline page, select a measure, a calculation method, a trend line type, and a trend period.
Click OK. The following figure shows the effect of the trend line.
