You can use a single value chart (Pro) to visualize the results of multiple query statements. You can also configure custom settings for fields. This topic describes how to configure a single value chart (Pro) to display query results.

Background information

A single value chart (Pro) contains one or more single value charts. Each single value chart is used to display a single numeric value. The following figure shows a sample single value chart (Pro). Each colored rectangle in the single value chart (Pro) represents a single value chart.

Single value chart (Pro)

Common Settings tab

On the Common Settings tab, you can configure global settings for the single value chart (Pro).

  • Basic Configurations sectionSingle value chart (Pro)
    Parameter Description
    Title The title of the single value chart (Pro).
    Show Title If you turn on Show Title, the title of the single value chart (Pro) is displayed.
    Show Border If you turn on Show Border, the borders of the single value chart (Pro) are displayed.
    Show Background If you turn on Show Background, the background color of the single value chart (Pro) is displayed.
    Show Time If you turn on Show Time, the query time range of the single value chart (Pro) is displayed.
    Fixed Time If you turn on Fixed Time, the specified time range remains unchanged regardless of whether the global time range of the dashboard changes.
  • Standard Configurations sectionColumn chart
    Parameter Description
    Format The display format of numeric values.
    Unit The unit of numeric values.
    Number of Digits after Decimal Point The number of digits after the decimal point of numeric values.
    Display Name The display name of single value charts.

    If you specify a display name, the name of each single value chart in the single value chart (Pro) is changed to the specified value. If you want to modify the display name of a specific single value chart, you can configure a name on the Fields tab.

    Color Scheme The color scheme that specifies the background color of the single value chart (Pro).
    • Built-in: The built-in color is used.
    • Solid: You can select a color.
    • Threshold: The color of each single value chart is based on the threshold settings.
  • Data Configuration sectionSingle value chart (Pro)
    Parameter Description
    Display Mode

    The display mode of single value charts.

    • Calculation Result: Each single value chart displays the calculation result of a field that you specified in the result of a query statement.
    • All Values: Each single value chart displays a value of the field that you specified in the result of a query statement.
    Function

    If you set the Display Mode parameter to Calculation Result, you must select a function to query statistics on the field that you specified in the result of a query statement.

    For example, if you set the Function parameter to Maximum, the maximum value of the field that you specified in the result of each query statement is displayed on the single value chart (Pro).

    Limit

    If you set the Display Mode parameter to All Values, you can configure the Limit parameter to specify the number of single value charts that you want to display on the single value chart (Pro).

    Layout Mode
    The layout of single value charts.
    • Automatic: The single value charts are arranged in an adaptive manner.
    • Horizontal: The single value charts are arranged from left to right.

      You can also specify the minimum width for single value charts.

    • Vertical: The single value charts are arranged from top to bottom.

      You can also specify the minimum height for single value charts.

  • Chart Style sectionChart Style section
    Parameter Description
    Text Mode The text that you want to display on single value charts.
    • Auto: Text is displayed based on the field that you specified in the result of a query statement.
    • Value: Only numeric values are displayed.
    • Value and Title: Numeric values and titles are displayed.
    • Title: Only titles are displayed.
    • None: No content is displayed.
    Color Mode The color of single value charts.
    • None: Text is displayed in black.
    • Value: Only the mini-charts and numeric values of the single value charts are displayed in the specified color.
    • Background: The background and mini-charts of the single value charts are displayed in the specified color.
    Image Mode

    Specifies whether to display mini-charts.

    • None: No mini-charts are displayed.
    • Mini-chart: Mini-charts are displayed.
      Note The Mini-chart parameter takes effect only if the Display Mode parameter is set to Calculation Result.
    Text Alignment

    The mode in which the text of each single value chart is aligned.

    • Automatic: Text is aligned in an adaptive manner.
    • Center: The text is located in the center of the single value charts.
  • Search & Analysis Settings sectionSearch & Analysis Settings section
    Parameter Description
    Displayed Field The field whose values you want to display on single value charts.
    Compared Field The field whose values you want to compare with the values of the displayed field.
    Note The settings take effect only if the Display Mode parameter is set to Calculation Result. The specified function applies to the displayed fields and compared fields.
    Compare Value Format The format of the value of the compared field.
    Comparison Result Description The description of the value of the compared field.
    Number of Digits after Decimal Point The number of digits after the decimal point of the value of the compared field.
    Description Font Size The font size of the description.
  • Threshold sectionTable (Pro)
    Parameter Description
    Threshold The thresholds of numeric values.

    If you set the Color Scheme parameter to Threshold and specify thresholds in the Threshold section, the text on each single value chart of the single value chart (Pro) is displayed in the corresponding color.

  • Mapping Value sectionTable (Pro)
    Parameter Description
    Mapping Value The text or icon that is used to replace a specified value in the single value chart (Pro).

    For example, if you set the Value parameter to 200, the Mapping Type parameter to Text, and the Mapping Value parameter to Success, all values of 200 on the single value chart (Pro) are replaced by Success.

Fields tab

You can configure custom display settings for the result of a single query statement or for a single column in the result. For information about the parameters on the Fields tab, see Common Settings tab.

In this example, five query statements named A, B, C, D, and E are added to calculate the number of requests for each status code. The results of the query statements are displayed on a single value chart (Pro). To specify a color for the single value chart of each query statement, perform the following steps: Click the Single Value Chart Pro icon, choose Common Settings > Search & Analysis Settings, and then specify a displayed field for each query statement to generate five single value charts. On the Fields tab, configure different colors for the single value charts. The following figure shows the single value chart (Pro) and related settings.
  • A > GET indicates that the GET column in the result of the query statement A is selected as the displayed field. The color of the corresponding single value chart is purple.
  • B > POST indicates that the POST column in the result of the query statement B is selected as the displayed field. The color of the corresponding single value chart is blue.
  • C > PUT indicates that the PUT column in the result of the query statement C is selected as the displayed field. The color of the corresponding single value chart is orange.
  • D > D indicates that the D column in the result of the query statement D is selected as the displayed field. The color of the corresponding single value chart is yellow. DELETE is a keyword in SQL syntax and cannot be used as a column name in analytic statements. In this case, you can specify DELETE as the display name for the D column on the Fields tab.
  • E > HEAD indicates that the HEAD column in the result of the query statement E is selected as the displayed field. The color of the corresponding single value chart is red.
Single value chart (Pro)