Help Center> Data Lake Visualization> User Guide (ME-Abu Dhabi Region)> Component Guide> Line Chart Components> Dual Y-Axis Line (WT)
Updated on 2023-12-20 GMT+08:00
View PDF

Dual Y-Axis Line (WT)

A WT dual Y-axis line chart is a chart component of the wide table (WT) type. It can be used to display the data change trend of multiple series under each category. One category can display the data of multiple series. A WT dual Y-axis line chart contains two series by default. You can add a series value of a field that represents a series in the source data table to be a series. You can add multiple series. Each series of data is marked on coordinates in the form of points, and connected to points in a line.

Figure 1 WT dual Y-axis line chart

Pattern

  • Size/Position
    • Size: width and height of the component. Unit: pixel.
    • Position: position where the component is located in the canvas. Unit: pixel.
  • Global Style
    • Font: font of the text.
    • Curve: When this function is enabled, the broken lines become curved lines.
      Figure 2 Curve of a WT dual Y-axis line
  • Margin
    • Top: spacing between the top sides of the chart and the component layer. You can enter a value or click to adjust the spacing.
    • Bottom: spacing between the bottom sides of the chart and the component. You can enter a value or click to adjust the spacing.
    • Left: spacing between the left sides of the chart and the component. You can enter a value or click to adjust the spacing.
    • Right: spacing between the right sides of the chart and the component. You can enter a value or click to adjust the spacing.
  • X Axis: to show or hide the X axis. When this option is selected, you can set the X axis style.
    • Font Size: font size of the axis label text.
    • Color: font color of the axis label text.
    • Font Width: font width of the axis label text.
    • Angle: tilt angle of the axis label text.
    • Data Type: data type of the field corresponding to the axis. The value can be Value, Category, Time, or Log.
    • Scales: When Data Type is set to Value or Time, the number of displayed labels is automatically displayed based on the value of Scales. This parameter is invalid when Data Type is set to other values.
    • Color: color of the axis.
    Figure 3 X axis of a WT dual Y-axis line chart
  • Y1 Axis
    • Font Size: font size of the axis label text.
    • Color: font color of the axis label text.
    • Font Width: font width of the axis label text.
    • Angle: tilt angle of the axis label text.
    • Axis Label: to show or hide the axis labels. When this function is enabled, you can set the following parameters:
      • Display Format: display format of the scale value on the axis.
      • Min. Value: the minimum value of the axis. You can enter a value or select a value from the drop-down list. When this parameter is set to the minimum value, the start value of the axis is the minimum value in the current data.
      • Max. Value: the maximum value of the axis. You can enter a value or select a value from the drop-down list. When this parameter is set to the maximum value, the start value of the axis is the maximum value in the current data.
      • Scales: intervals of data items on the coordinate axis.
    • Axis Unit: to show or hide the axis unit. When this function is enabled, the axis unit is displayed on the top of the chart. The unit can be displayed only when Top under Margin is set to a value greater than or equal to 40.
      • Unit: unit of the coordinate axis, for example, kilometer, byte/second, or GB.
      • Color: font color of the text.
    • Coordinate Axis: to show or hide the axis. You can set the color of the axis when you select this option.
    • Grid Line: to show or hide the grid lines. You can set the color of the grid lines when you select this option.
    Figure 4 Y1 axis of a WT dual Y-axis line chart
  • Y2 Axis

    The Y2 axis is the Y axis on the right. The configuration items are the same as those of the Y1 axis. For details, see the description of Y Axis.

  • Legend: to show or hide the legend. When this option is selected, you can set the legend style.
    • Text: text style of the legend, including Font Size, Color, and Font Width.
    • Layout: position where the legend is located in the component.
    Figure 5 Legend
  • Message: to show or hide the prompt information. After this function is enabled, a message is displayed when you mouse over or click on the screen during the screen preview.
    • Triggering Type: type of the prompt message.
    • Color: font color of the message.
    • Font Size: font size of the message.
    • Font Width: font width of the message.
    Figure 6 Message
  • Animation
    • Click or next to Animation to hide or show animation, respectively.
    • Duration: duration of the first rendering of the component, in ms.
    • Animation Effect: The system provides multiple common animation slow-moving effects.
    • Animate in Order: If this option is selected, the series are animated in sequence. If this option is deselected, all series are animated at the same time.
    • Duration After Change: animation duration when the component data is updated, in ms.
    • Start from Previous Position: If this option is selected, the animation is played from the position of the previous data when the component data is updated. If this option is deselected, the animation is played from the initial position when the component data is updated.
    Figure 7 Animation (line chart)

Data

The data format of the WT dual Y-axis line chart is a wide table structure. The related fields are placed in the same table to form a database table with many fields. The WT dual Y-axis line chart contains three fields by default: x, y1, and y2.

  • Data Source Type: to select the data source of the chart. Multiple data sources are provided for you to select. You need to add data sources first. For details, see Data Connection Overview.
  • x: category of a line chart or bar chart, corresponding to the X axis.
  • y:
    By default, the following two series are included:
    • y1: data of the y1 series. y1 is the field name in the mapped source data. y1 corresponds to the left Y1 axis by default.
    • y2: data of the y2 series. y2 is the field name in the mapped source data. y2 corresponds to the right Y2 axis by default.

    Click on the right of y to add a series. To delete an added series, click on the right of the series.

    Add a series as follows:

    • Series Value: field name in the mapped source data.
    • Series Name: self-definable. If the series name is empty, the series value is used as the series name by default.
    • Shape: shape of the points on the line.
    • Color: color of the line.
    • Width: line width of the line.
    • Opaque: opacity of the area covered by the broken line. A larger value indicates lower transparency.
    • Reference Axis: Y1 axis or Y2 axis.
    • Value Tag: to show or hide the value tag. After selecting this option, you can set the font size, color, font width, and position of the value tag.
    • Link: target link to which the web page points when a data item in component widget is clicked.
    • Link Mode:
      • New window: The target link opens a new browser window.
      • Current page: The target link opens a window in the current browser window.
      • Floating panel: The target link opens a floating window in the center of the current screen.
  • Automatic Update: If you select Automatic Update and set Update Interval, the data is automatically updated based on the interval.
  • Preview Result: Click Preview Result to view the information about the selected data source. You can click Update Query to manually update the component data when the data source changes.
Figure 8 Data of the WT dual Y-axis line chart

Interaction

For details about whether the component supports the interaction function and how to use the interaction function, see Configuring Component Interaction.

Parent topic: Line Chart Components