Advanced
Тема интерфейса

Dashboard

Язык статьи: Английский
Перевести

DataArts Insight allows you to set dashboards. This section describes how to create a dashboard.

Notes and Constraints

  • The metric axis is determined by the metrics of the data and at least one metric must be selected.

Prerequisites

Procedure

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

    Figure 1 Dashboard


Field

Set dashboard fields.

  1. In the right pane of the dashboard creation page, click Field. Select the required metrics.

    In the metric list, select the field and drag it to the dashboard metric area.

  2. 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.

  3. 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.
  4. 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.

  5. Set automatic refresh.

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

Style

Set dashboard style parameters based on Table 2 and Table 3.

Table 2 Dashboard style parameters

Parameter

Description

Card Title

Cards can be configured with or without a title. If a title is set, it will be displayed in the top left corner of the card.

If the checkbox is not selected (), the card will have no title.

If the checkbox is selected (), the card will have a title.

Text

You can adjust the font size and color of the text. To change the font size, you can either type in the desired size or use the and buttons.

NOTE:

Note that the input cannot be empty and must be from 14 to 32.

Alignment

You can align the text in the card to the left or center.

Bottom Margin

Set the distance between the dashboard title and the chart. To change the margin, you can either type in the desired margin or use the and buttons.

NOTE:

Note that the input cannot be empty and must be from 0 to 32.

Divider

Cards can be configured with or without a divider line.

If the checkbox is not selected (), the card will have no divider line.

If the checkbox is selected (), the card will have a divider line. You can customize the style and bottom margin of the divider line. The style and bottom margin can be set by inputting values or using the and buttons.

NOTE:

Note that the input for the style cannot be empty and must be from 0 to 8. The bottom margin can only be set after the style has been set, and the input cannot be empty and must be from 0 to 32.

Card Background

Cards can be configured with or without a background.

If the checkbox is not selected (), the card will have no background.

If the checkbox is selected (), the card will have a background. The background color can be set.

Status Icon

You can customize the display style and color of the icon, which can be set to always show or show on hover. The card icon can be set to have a status or no status.

If the checkbox is not selected (), the icon will have no status.

If the checkbox is selected (), the icon will have a status.

Table 3 Dashboard chart style parameters

Parameter

Description

Visualization Style

Set the coordinate line and color of the coordinate axis.

Value Settings

Set the text and text color of axis labels.

Data Label

Set the thickness and color of grid lines.

Measurement Axis Color Configuration

Set the scale type, which can be linear or logarithmic.

Scale Partition

Set the intervals of dashboard's tick marks.

Start Point

Set the start point to a fixed or dynamic value.

End Point

Set the end point to a fixed or dynamic value.

Coordinate Axis: You can set the font size for axis labels.

Table 4 Series settings

Parameter

Description

Select Metric

Select metrics based on the metrics selected on the Field tab.

Context

Set the context for the series, supporting Simplified Chinese and English.

Unit

Units support automatic, none, hundred, thousand, ten thousand, hundred million, ten billion, and trillion.

Scientific Notation

Support the use of scientific notation.

Use thousands separator

Whether or not to use thousands separators.

Decimal Places

Whether or not to support decimal places.

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 5 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.