This topic describes three analysis methods: auxiliary line, trendline, and fluctuation analysis.

Background information

The following table lists charts that support these analysis methods.
Chart type Auxiliary line Trendline Fluctuation analysis
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 Dashboard overview and Create a dashboard.

Auxiliary line

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

Fluctuation analysis

The fluctuation analysis feature uses machine learning algorithms to analyze the causes of the fluctuations of key metrics. You can specify the dimensions or measures to analyze the fluctuation causes.

  1. Click the Workspace tab. In the left-side navigation pane, click Dashboards. On the Dashboards page, find the required dashboard and click the Edit icon icon.
  2. On the dashboard edit page, click the required chart.
  3. On the Advanced tab of the Graphic Design pane, click the Edit icon icon next to Fluctuation Analysis in the Metric Analysis section.
    Note The charts that meet both of the following conditions support fluctuation analysis:
    • A time dimension (except hour, minute, and second) is selected for the category axis.
    • At least one measure uses the aggregate method SUM, COUNT, or COUNT DISTINCT.
  4. In the Fluctuation Analysis Settings dialog box, configure Compare Objects and Analysis Dimension, and click OK.
  5. Click a time point in the chart and then click Fluctuation Analysis.Fluctuation Analysis
  6. In the Fluctuation Analysis dialog box, select a measure to view the key factors that affect the measure.Analysis results
    Note
    • Change contribution rate of a dimension = Change of the measure to be analyzed caused by the dimension/Total change of the measure to be analyzed
    • The change contribution rate of a measure indicates how much the measure affects the measure to be analyzed. A great value indicates a great impact.