This topic describes the metric analysis feature of Quick BI. This feature uses the auxiliary line, trendline analysis methods.

Background information

The following table lists analysis methods supported by different types of charts.
Chart type Auxiliary line Trendline
Line chart
Area chart
Stacked area chart -
100% stacked area chart -
Vertical bar chart
Stacked vertical bar chart -
100% stacked vertical bar chart -
Horizontal bar chart
Stacked horizontal bar chart -
100% stacked horizontal bar chart -
Combination chart
Trend indicator - -
Scatter chart -
Bubble chart -

Prerequisites

A dashboard is created. For more information, see Create dashboards.

Auxiliary line

You can add an auxiliary line to view the difference between the value of a measure and the value shown by the auxiliary line. The value shown by an auxiliary line is a fixed or aggregate value. Supported aggregate functions include AVG, MAX, MIN, and Median.
  1. Log on to the Quick BI console.
  2. Click the Workspace tab. In the left-side navigation pane, click Dashboards. On the Dashboards page, find the target dashboard and click the Edit icon in the Actions column.
  3. Click the chart for which you want to configure an auxiliary line.
  4. On the Advanced tab of the Graphic Design pane, click the Edit icon next to Gridlines in the Metric Analysis section.
  5. In the Auxiliary Line dialog box that appears, click Add Auxiliary Line. Select a value type for the auxiliary line you want to create.Advanced tab
  6. Click OK. The following figure shows a sample auxiliary line.Auxiliary Line