Stacked Area Chart

Notes and Constraints

• The dimension axis is determined by the dimensions of the data and at least one dimension must be selected, such as date, province, or product type.
• The metric axis is determined by the metrics of the data and at least one metric must be selected, such as order quantity.
• The color legend is determined by the dimensions of the data and only one dimension can be selected.
• The color legend can only be enabled when a metric field is selected on the value axis.
• The chart will display label values if the query limit is 14 or less, but not if it is greater than 14.

Procedure

1. In the top navigation bar on the dashboard creation page, click to create a stacked area chart template.
2. Select a dataset in the Data area.
3. Set parameters on the Field, Style, and Advanced tabs.
4. Click Update. The system automatically updates the chart.

   Figure 1 Stacked area chart

   
   
5. Click Save or Save and Publish in the upper right corner to save the intelligent chart.
   Note

   Click Save in the upper right corner. In the displayed dialog box, enter the dashboard name, and click Confirm. The saved dashboard cannot be viewed but can be deleted.

   Click Save and Publish to save and publish the dashboard. You can view the saved dashboard. To delete the dashboard, you need to take it offline first.

6. On the displayed dashboard page, enter a dashboard name.

Field

1. Set dimension and metric fields.
   1. Select data.
      1. In the dimension and metric lists within the data columns, select the desired dimensions and metrics.
      2. In the dimension list under the data columns, select the field or drag it to the dimension column of the field.
      3. In the metric list under the data columns, select the field or drag it to the metric column of the field.
   2. Set the field display content.

      Click in the column, select Field Display Content and click to modify the field display content on the displayed page. Click OK.

   3. Set the drill-down.

      Columns support the setting of field display content modification and drill-down functions for dimension fields.

      Note

      Drill-down function: When analyzing company sales data, you can change the analysis granularity by drilling down the data, such as drilling down from the regional granularity to the provincial granularity to view the data situation based on geographic dimensions. Connecting data from various dimensions facilitates data analysts to analyze the data and draw conclusions.

      1. Click the field () in the column and drag the field of the target location to be drilled down to the Drilldown area.
      2. Click Update to test whether the drilldown function is set successfully.
   4. Set the aggregation mode.

      Columns support the setting of aggregation method and field display content for metric fields.

      Note

      Aggregation method: Perform calculation and processing on data to make the analyzed data more orderly and intuitive.

      Click of the field in the column, select Aggregation Method and click to support setting of no aggregation, sum, count, distinct count, maximum value, minimum value, average value, population standard deviation, sample standard deviation, sample variance, range start value, and range end value.

2. Set color legend (dimension).

   Drag the required fields to the Color Legend (Dimension) area on the Field tab. The color legend also supports drill-down.

3. Set a filter.
   1. Drag dimension and metric fields to the Filter area.
   2. Click next to a field in the Filter area.
   3. In the displayed Set Filter dialog box, set the parameters and click OK.

      Table 1 Filter parameters

      Type	Parameter	Description
      String	Condition	Filter Mode: The options are Condition and Enumeration. Condition Type: The options are And condition and Or condition. Filter Condition: The options are Exact match, Contain, Start with, End with, Not match, Not contain, Null, and Not null.
      	Enumeration	Query Mode: The options are Single-select and multi-select. Filter Condition: The options are >, ≥, <, ≤, =, ≠, Null, and Not null.
      Metric	Condition Type	The options are And condition and Or condition.
      	Filter Condition	The options are >, ≥, <, ≤, =, ≠, Null, and Not null. You can select Before aggregation and After aggregation for data. NOTE: If you select Before aggregation, data is filtered before aggregation. If you select After aggregation, data is filtered after aggregation. For aggregation concepts, see Creating a Dataset. You can click Create Filter Condition to set multiple filter criteria.
      Date	Range value	Select a time range for filtering.
      	Single value	Set a single time for filtering.
      	Condition	You can select And condition or Or condition as the condition type and select filter condition like >, ≥, <, ≤, and =. You can click Create Filter Condition to set multiple filter criteria.

4. Set sorting.
   1. Drag and drop required data fields from the Dimension and Metric (Indicator) areas under Data to the Sorting area.
   2. Click next to a field in the Sorting area and select a sorting mode. The sorting modes are Ascending, Descending, and Custom.
   3. To cancel sorting, click next to the sorting field.
5. Set the maximum number of query results.

   Enter the maximum number of records that can be returned in the text box. The default value is 1000.

6. Set automatic refresh.

   The auto refresh interval supports the following options: no refresh, 1 minute, 5 minutes, 15 minutes, and 30 minutes.

Style

Advanced

• Linkage

  Click the Advanced tab and click next to Linkage. The Chart Linkage Settings page is displayed. Set parameters. For details, see Linkage example.

  Table 6 Chart linkage configurations

  Parameter	Description
  Filter	Select the fields to be bound first and then select the chart to be associated with them. You can select all charts on the dashboard.
  Associated Charts	Link the associated charts. Follow bound field: When the bound field is set to A, the associated data tables filter data related to A. SQL placeholder: The bound field value corresponds to the value set for the SQL placeholder in the dataset.

• Initialize Query for Associated Query Control: whether the associated query control supports query initialization. If the checkbox is selected (), the control supports query initialization. If the checkbox is not selected (), the control does not support query initialization.
  Note

  If you select this option, when a chart is linked to a query control and the query control does not have a default query set, the chart's data configuration will be queried during chart initialization.