All Products
Search
Document Center

Simple Log Service:Display query results on a single value chart

最終更新日:Aug 02, 2023

This topic describes how to configure a single value chart to display query results.

Background information

The single value chart highlights a single value. Single value charts include the following types:

Rectangle Frame is selected by default. A rectangle frame is the most basic method to display data at a specified point. In most cases, it is used to show the key information at a specified time point. To display a proportional metric, you can select Dial.

Each single value chart consists of the following elements:

  • Numeric value

  • Unit (optional)

  • Description (optional)

  • Chart type

Procedure

  1. Log on to the Log Service console.
  2. In the Projects section, click the name of the project that you want to manage.
  3. Choose Log Storage > Logstores and click the Logstore that you want to manage.
  4. Enter a query statement in the search box, select a time range, and then click Search & Analyze.
  5. On the Graph tab, click the Single value chart - 001 icon.

  6. On the Properties tab, configure the properties of the single value chart.

    Note

    Simple Log Service normalizes data in numeric value-based charts. For example, 230000 is processed as 230K. You can include Mathematical calculation functions in query statements to customize numeric formats.

    • The following table lists the parameters of a rectangle frame.

      Parameter

      Description

      Chart Types

      The type of the single value chart. If you select Rectangle Frame for this parameter, query results are displayed in a rectangle frame.

      Value Column

      The value displayed in the chart. By default, data in the first row of the specified column is displayed.

      Unit

      The unit of data.

      Unit Font Size

      The font size of the unit. You can drag the slider to adjust the font size. Valid values: 10 to 100. Unit: pixels.

      Description

      The description of the value.

      Description Font Size

      The font size of the value description. You can drag the slider to adjust the font size. Valid values: 10 to 100. Unit: pixels.

      Format

      The format in which data is displayed.

      Font Size

      The font size of the value. You can drag the slider to adjust the font size. Valid values: 10 to 100. Unit: pixels.

      Font Color

      The color of the value, unit, and description in the chart. You can use the default color or select a color.

      Background Color

      The color of the background. You can use the default color or select a color.

    • The following table lists the parameters of a dial.

      Parameter

      Description

      Chart Types

      The type of the single value chart. If you select Dial for this parameter, query results are displayed on a dial.

      Actual Value

      The actual value in the chart. By default, data in the first row of the specified column is displayed.

      Unit

      The unit of the value on the dial.

      Font Size

      The font size of the value and unit. Valid values: 10 to 100. Unit: pixels.

      Compare Value

      The field value to be compared. The value of the selected field is displayed on the dial.

      Contrast Value Font Size

      The font size of the compare value.

      Unit of Compared Values

      The unit of the compare value.

      Description

      The description of the value.

      Description Font Size

      The font size of the value description. You can drag the slider to adjust the font size. Valid values: 10 to 100. Unit: pixels.

      Dial Maximum

      The maximum value of the scale on the dial. Default value: 100.

      Maximum Value Column

      The maximum value in the specified column. If you turn on the Use Query Results switch, Dial Maximum is replaced by Maximum Value Column. Then, you can select the maximum value from the query results for this parameter.

      Use Query Results

      If you turn on the Use Query Results switch, Dial Maximum is replaced by Maximum Value Column. Then, you can select the maximum value from query results for this parameter.

      Format

      The format in which data is displayed.

      Colored Regions

      The number of segments to divide the dial. Each segment is displayed in a different color.

      Valid values: 2, 3, 4, and 5. Default value: 3.

      Region Max Value

      The maximum value of the scale in each colored segment of the dial. By default, the maximum value in the last segment is the maximum value on the dial. You do not need to specify this value. If you turn on the Use Query Results switch, Region Max Value is replaced by Region Percentage.

      Note

      A dial is evenly divided into three colored segments by default. If you change the value of Colored Regions, Region Max Value is not automatically adjusted. You can manually set the maximum value for each colored segment based on your business requirements.

      Font Color

      The color of the value on the dial.

      Region

      The colored segments to divide the dial. A dial is evenly divided into three segments by default. The segments are displayed in blue, yellow, and red.

      If you set Colored Regions to a value greater than 3, the added segments are displayed in blue by default. You can change the color of each segment.

    • The following table lists the parameters of a compare numb chart.

      Parameter

      Description

      Chart Types

      The type of the single value chart. If you select Compare Numb Chart for this parameter, query results are displayed on a compare numb chart.

      Show Value

      The value that is displayed in the center of the compare numb chart. In most cases, this value is set to the statistical result that is calculated by the related comparison function in the specified time range.

      Compare Value

      The value that is compared with the threshold. In most cases, this value is set to the result of comparison between the statistical results calculated by the related comparison function in the specified time range and in the previously specified time range.

      Font Size

      The font size of the show value.Valid values: 10 to 100. Unit: pixels. You can turn on the Adaptive switch to enable the adaptive feature of the font size.

      Unit

      The unit of the show value.

      Unit Font Size

      The font size of the unit for the show value. Valid values: 10 to 100. Unit: pixels.

      Compare Unit

      The unit of the compare value.

      Compare Font Size

      The font size of the compare value and unit. Valid values: 10 to 100. Unit: pixels.

      Description

      The description of the show value and its growth trend. The description is displayed under the value.

      Description Font Size

      The font size of the description. Valid values: 10 to 100. Unit: pixels.

      Trend Comparison Threshold

      The value that is used to measure the variation trend of the compare value.

      For example, the compare value is -1.

      • If you set Trend Comparison Threshold to 0, a down arrow that indicates a value decrease is displayed on the page.

      • If you set Trend Comparison Threshold to -1, this indicates that the value remains unchanged. The system does not display the trend on the page.

      • If you set Trend Comparison Threshold to -2, an up arrow that indicates a value increase is displayed on the page.

      Show Value Format

      The format in which the show value is displayed.

      Compare Value Format

      The format in which the compare value is displayed.

      Font Color

      The color of the show value and its description.

      Growth Font Color

      The font color of the compare value that is greater than the threshold.

      Growth Background Color

      The background color displayed when the compare value is greater than the threshold.

      Decrease Font Color

      The font color of the compare value that is less than the threshold.

      Decrease Background Color

      The background color displayed when the compare value is less than the threshold.

      Equal Background Color

      The background color displayed when the compare value is equal to the threshold.

Examples

To view the number of requests, execute the following query statements:

  • Rectangle frame

    * | select count(1) as pv
    Rectangle frame
  • Dial

    * | select count(1) as pv
    Compare numb chart
  • Compare numb chart

    To view and compare the requests for today and yesterday, execute the following query statement:

    * | select diff[1],diff[2], diff[1]-diff[2] from (select compare( pv , 86400) as diff from (select count(1) as pv from log))
    Dial