Line Chart and Clustered Column Chart

Notes and Constraints

• The dimension axis is determined by the dimensions of the data and at least one dimension must be selected, such as date, province, or product type.
• The metric axis is determined by the metrics of the data and at least one metric must be selected, such as order quantity.
• The color legend is determined by the dimensions of the data and only one dimension can be selected.
• The color legend can only be enabled when a metric field is selected on the value axis.
• The chart will display label values if the query limit is 14 or less, but not if it is greater than 14.

Procedure

1. In the top navigation bar on the dashboard creation page, click to create a line chart and clustered column chart template.
2. Select a dataset in the Data area.
3. Set parameters on the Field, Style, and Advanced tabs.
4. Click Update. The system automatically updates the chart.
   Figure 1 Line chart and clustered column chart
   
5. Click Save or Save and Publish in the upper right corner to save the chart.
   

   Click Save in the upper right corner. In the displayed dialog box, enter the dashboard name, and click Confirm. The saved dashboard cannot be viewed but can be deleted.

   Click Save and Publish to save and publish the dashboard. You can view the saved dashboard. To delete the dashboard, you need to take it offline first.

6. On the displayed dashboard page, enter a dashboard name.

Field

• In the Data area on the right, select a dataset, and double-click or drag required dimension and metric fields to the corresponding areas on the Fields tab.

  Table 1 Parameters on the Field tab

  Parameter	Description
  Field display content	Click in the column and click Field display content to modify the field display content on the displayed page. Click OK.
  Aggregation Method	Select Aggregation Method and click to support setting of no aggregation, sum, count, distinct count, maximum value, minimum value, average value, population standard deviation, sample standard deviation, sample variance, range start value, and range end value.
  Drilldown	You can enable drilldown for dimension fields. For example, you can view data at different levels of granularity, ranging from years down to quarters, months, weeks, days, hours, minutes, and even seconds, depending on the time dimension. Click the field () in the column and drag the field of the target location to be drilled down to the Drilldown area. Click Update to test whether the drilldown function is set successfully. NOTE: Drill-down is only supported for dimension fields, not for metric fields. You can only select one field as the starting point for drill-down. When drilling down on time, the system will automatically add the subdivided time periods to the drill-down order list and include them in the sorting field (fields that are already in the sorting field will not be added again). Drill-down icons should be highlighted for fields that have already been drilled down. If you remove the drill-down field from the dimension, the entire drill-down function box will disappear.

Style

• Set the style.

  Table 2 Basic Settings

  Parameter	Description
  Card Title	Whether to display the card title. If selected, the card title is displayed in the upper left corner of the chart.
  Text	Set the text size and click to select the text color.
  Alignment	Set the alignment mode, which can be left alignment or center alignment.
  Bottom Margin	Set the distance between the card title and the chart.
  Divider	Whether to display the divider. You can set the size, color, and bottom margin of the divider.
  Card Background	Whether to display the card background. Click to select a background color.
  Status Icon	Whether to display the status icon. You can set the display mode and color of icons. The display modes include Always display and Hover display.
  Hide Panel Operations	You can customize whether to display in the upper right corner of the chart.
  Panel No Padding	You can customize whether to cancel card padding.

  Table 3 Chart style

  Parameter	Description
  Show Legend	Choose whether to display the legend. If the checkbox is not selected (), the legend will not be displayed. If the checkbox is selected (), the legend will be displayed.
  Text	Set the font size for text when the legend is displayed.
  Position	Choose to display the legend below or above the chart.
  Color Palette	Set the color palette for the legend, with the option to use system defaults and customize ones.
  Context	Specify the language context for numerical values, with support for Simplified Chinese and English.
  Unit	Choose the unit of measurement for numerical values, including options for none, automatic, hundred, thousand, ten thousand, hundred million, and billion.
  Scientific Notation	Set whether to support scientific notation for numerical values.
  Use thousands separator	Set whether to use thousands separators for numerical values.
  Decimal Places	Set whether to display decimal places for numerical values.

  Table 4 Coordinate axis

  Parameter	Description
  Show Title and Unit	Customize whether to show the title and unit. You can set the axis title, unit, position, and text.
  Auto Set Numeric Range	You can control the data display range of the chart by setting minimum and maximum values.
  Show Axis	Customize whether to show the coordinate axis. You can set the font size and color of coordinate lines.
  Show Axis Label	Customize whether to show axis labels. You can set the font size, color, and display format of axis labels.
  Show Grid Line	Customize whether to show gridlines. You can set the weight and color of gridlines.
  Show Scale Line	Customize whether to show gridlines' scale lines.
  Scale Type	The X-axis supports ordinal scale type, while the Y-axis supports ordinal scale type.
  Abbreviated Axis Label	Set the X-axis label abbreviation.

  Table 5 Function configuration

  Function	Description
  Abbreviated Axis	Set whether to enable the abbreviated axis.
  Abbreviated Axis Background Data	Set the background data display for the abbreviated axis.
  Null Value Processing	Set the rule for handling null values: Delete, intelligently delete, set to zero, or break on null.

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 6 Chart linkage settings

  Parameter	Description
  Fields to Bound	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	Set linked associated charts. You can select charts from the same dataset or different datasets. 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.
  

  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.