A column chart (Pro) can be a column chart or a bar chart. You can use a column chart (Pro) to visualize the results of multiple query statements. You can also configure personalized display settings on the Fields tab. This topic describes the basic configurations of a column chart (Pro).

Introduction

A column chart uses vertical bars to show the values of different categories. You can use a column chart to display the number of values in each category. A bar chart uses horizontal bars. Bar charts are often used in top-N analysis.

For more information about how to create a column chart or a bar chart, see Add a chart (Pro) to a dashboard.

Configurations on the Common Settings tab

You can configure global settings for a column chart on the Common Settings tab.

  • Parameters in the Basic Configurations sectionColumn chart
    Parameter Description
    Title The title of the column chart.
    Show Title If you turn on Show Title, the title of the column chart is displayed.
    Show Border If you turn on Show Border, the borders of the column chart are displayed.
    Show Background If you turn on Show Background, the background color of the column chart is displayed.
    Show Time If you turn on Show Time, the time range of a query is displayed in the column chart.
    Fixed Time If you turn on Fixed Time, the time range of a query for the column chart is independent of the global time range of the dashboard.
  • Parameters in the 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 decimal places of numeric values.
    Display Name The name of the legend.

    If you specify a value for Display Name, the value is used as the names of all legends in the column chart. If you want to change the name of a legend, you must configure parameters on the Fields tab.

    Color Scheme The color scheme of the column chart. The color scheme is applied to the background and legends of the column chart.
    • Built-in: uses the built-in color scheme.
    • Solid: uses the color that you select.
  • Parameters in the Column Settings sectionColumn chart
    Parameter Description
    Direction The direction of the columns in the chart. The direction is used to distinguish between column charts and bar charts.
    • Vertical: indicates a column chart.
    • Horizontal: indicates a bar chart.
    Group Width The width of the group.
    Column Width The width of the column.
    Rotation Angle The direction of the text in the x-axis.

    If you set Direction to Vertical, you must configure this parameter.

    Show Value Specifies whether to display numeric values in the column chart.
    Value Font Size The size of the text displayed in the column chart.
    Connector Width The width of the border.
    Transparency The transparency of the column chart.
    Gradient Mode The gradient mode of the column chart.
    • Transparency: If you select this mode, the column chart has a color gradient that is affected by the column color and the value of Transparency.
    • No: If you select this mode, the column chart does not have a color gradient. The column color is used in the column chart.
  • Parameters in the Configure Query and Analysis sectionConfigure Query and Analysis
    Parameter Description
    Axis X Field Select a field as the x-axis.

    By default, Log Service automatically selects an appropriate field as the x-axis.

    Axis Y Field Select a field as the y-axis. You can specify multiple fields to generate a grouped column chart.

    By default, Log Service automatically selects an appropriate field as the y-axis.

  • Parameters in the Legend Configurations sectionColumn chart
    Parameter Description
    Display Legend If you turn on Display Legend, the legends of the column chart are displayed.
    Legend The location of the legend.
    Actions The data display effect when you click a legend.
    • Single: When you click a legend, only the data corresponding to the legend is displayed in the column chart.
    • Switch: When you click a legend, the data corresponding to the legend is hidden or displayed in the column chart.
    Maximum Width (Height)% The maximum width and height of the legend.
  • Parameters in the Tooltip Configurations sectionColumn chart
    Parameter Description
    Sorting Order The sorting method of data.

    When you move the pointer over a column whose data you want to view, the data is displayed based on the sorting method that you specify.

    Display Mode The display mode of data.

    When you move the pointer over a column whose data you want to view, the data is displayed based on the display mode that you specify.

  • Parameters in the Axis X sectionColumn chart
    Parameter Description
    Display Axis X If you turn on Display Axis X, the x-axis of the column chart is displayed.
    Axis X Title The title of the x-axis.
    Axis X Height The height of the x-axis.

    By default, Log Service automatically specifies the height of the x-axis

  • Parameters in the Axis Y sectionColumn chart
    Parameter Description
    Display Axis Y If you turn on Display Axis Y, the y-axis of the column chart is displayed.
    Axis Y Title The title of the y-axis.
    Axis Y Position The location of the y-axis.
    Axis Y Width The width of the y-axis.

    By default, Log Service automatically specifies the width of the y-axis.

    Max Value The maximum value of the y-axis.

    By default, Log Service automatically specifies the maximum value of the y-axis.

    Minimum The minimum value of the y-axis.

    By default, Log Service automatically specifies the minimum value of the y-axis.

    Elastic Maximum Value The elastic maximum value of the y-axis. The elastic maximum value takes effect only when all values of the y-axis are less than the elastic maximum value.

    By default, Log Service automatically specifies the elastic maximum value of the y-axis.

    Elastic Minimum Value The elastic minimum value of the y-axis. The elastic minimum value takes effect only when all values of the y-axis are greater than the elastic minimum value.

    By default, Log Service automatically specifies the elastic minimum value of the y-axis.

    Axis Y ID The ID of the y-axis. In most cases, this parameter does not take effect if you configure only one y-axis in Common Settings. If you want to configure multiple y-axes, you must configure parameters on the Fields tab. The ID of the y-axis is a string. A y-axis that has a specified ID represents a unique y-axis in a column chart.

    The configuration of the ID for the y-axis takes precedence over the unit that you specify in Standard Configurations. For example, if two y-axes have the same unit, the two y-axes are merged into one y-axis. If two y-axes have the same unit but different IDs, they are displayed as two y-axes.

Configurations on the Fields tab

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

For example, in the A > uv section, you can configure settings for the uv field in the results of Query Statement A. You can add a different y-axis so that the uv and avg fields are represented by different y-axes in the same column chart. In the following figure, the left y-axis displays the values of the avg field, and the right y-axis displays the values of the uv field.

Configurations on the Fields tab

Drill-down events

Drill-down events are used to analyze a single field or the results of a single query statement from a finer-grained dimension. Drill-down events include events to open a Logstore, open a saved search, open a dashboard, open trace analysis, open trace details, and customize an HTTP link. For more information, see Drill-down events.

For example, in the A section, you can configure an Open Logstore drill-down event for the results of Query Statement A. After you configure the event, you can click a point in the column chart and click Open Logstore. Then, you are navigated to the Logstore that you specify.

Column chart