Quick BI:Line Chart

Overview

Scenarios

• Trend widgets are used to display continuous data that changes over a specified period of time. You can use trend widgets when you want to show the overall trend of data at equal intervals.

• A line chart helps you learn the overall trend of data over a period of time. For example, data increases, decreases, periodically changes, or exponentially increases over a specific period of time. You can also compare data of multiple line charts.

Benefits

• Powerful computing capabilities: A vertical bar chart allows you to configure parameters, such as Comparison, Cumulative Calculation, Gridlines, and Trendline.

• Abundant data visualization: The chart type of a line chart can be a curve and a line chart. A line chart allows you to configure parameters, such as Label, Show Legend, and Show Scroll Bar.

• Data comparison and labeling: A line chart allows you to compare data in the same period and label data by using numbers.

Render example

Configure a line chart

1. On the Data tab, select dimensions and measures based on your business requirements.

   • In the Dimension list, double-click the product_type dimension. You can also drag this dimension to the Category Axis (Dim.) field.

   • In the Measures list, double-click Profit and Unit Price. You can also drag these measures to the Value Axis (Mea.) field.

   Note

   After you select Auto Refresh, the system automatically refreshes the line chart at a specified time interval. You can configure this parameter based on your business requirements.

2. Click Update to update the line chart.

   

Configure the style of a line chart

• In the Title and Card section, configure the notes and endnotes. For more information about how to configure a common chart style, see Configure the title area of a chart.

• In the drawing area, set the line chart style.

  

  Chart configuration items	Parameters
  Switch between visualized charts	The type of the chart. You can select Line Chart, area chart Chart, stacked area chart area chart, or Percentage Stacked area chart.
  Color Settings	You can specify a color for lines.
  Line Type	Curves and Lines are supported.
  Label Shape	Sets the shape of the marker point.
  process NULL values	The following methods are supported: Direct Crossing, Set to 0, Disconnect, and Line Break.
  Mobile client is selected by default	If you select this option, you can select Global Last Dimension Value or Last Dimension Value of Specified Series for Default Selection.

• In the Axes section, select Show Axes by default.

  You can select Show secondary Y-axis. The specified secondary Y-axis takes effect only when the number of added measures is greater than or equal to 2. If you select this option, Right Y Axis appears in the Axes section.

  

  Name	Parameter	Description
  X-axis	Display x-axis	Set whether to display x-axis.
  	Show Title and Unit	Specifies whether to show the title and unit of the X-axis.
  	Show Value	Set whether to display labels on the x-axis, axis label display rules, and text style.
  	Display content	Set Display Content to Some or All Dimensions.
  	Show Scale	Sets whether tick marks are displayed on the x-axis.
  	Show Axis	Specifies whether to display the X-axis, including line style, line width, and color of the X-axis.
  	Show Value	Specifies whether to show values on the X-axis.
  	Gridlines	Specifies whether to show gridlines on the X-axis, including the line style, line width, and color of the X-axis.
  Y-axis	Y-axis Scale Flip	You can set the flip y-axis scale value.
  	Show Left Y-Axis	Set whether to display the left Y-axis.
  	Show Title and Unit	Set whether to display the Axis Title and Unit.
  	Show Value	You can configure whether to display labels on the left Y-axis. You can also configure the labels, scale ranges, and axis labels.
  	Show Scale	Specifies whether to show scales on the left Y-axis.
  	Show Axis	Specifies whether to show the left Y-axis., including the line style, line width, and color of the left Y-axis.
  	Gridlines	Specifies whether to show gridlines on the left Y-axis, including the line style, line width, and color of the left Y-axis.
  	Axis Value Range and Interval	You can set the Maximum /Minimum value of the left Y-axis label and scale range based on Automatic or Manual Settings. You can set the Custom Interval to By step size or By Equal Number.

  Note

  The parameters on the Right Y-axis tab must be configured only if you select Dual Y-Axis in the Chart Style section. The parameter configuration on the Right Y-axis tab is the same as those Left Y-axis tab.

• In the Legend section, specify whether to show the legend and the legend style.

  • PC-side configuration

    

    Chart configuration items	Parameters
    Position	Set the legend display position. The following four legend rendering methods are supported.
    Text	Sets the legend text style.

  • Mobile terminal configuration

    

    Chart configuration items	Parameters
    Position /Multi-line Display	If you select Multi-line Display, you can view metrics in multiple lines. For example:
    	If you select Multi-line Display and Measure Name is long and hidden, you can use the Text Display feature. Example:
    Position /Row Tile Display	If you select this check box, you can change the value of Metrics to One Line Tile.
    Metric Display	If the metric is not selected, the display effect is “-” by default. You can switch to Empty.

• In the label, set whether to display the label and the label style.

  

  Chart configuration items	Parameters
  Full Display	Set whether to display full label.
  Position	Set the label display position.
  Text	Sets the label text style.

• In the Tooltip section, configure the tooltip mode.

  

  Chart configuration items	Parameters
  Display mode	The display mode of the prompt information. You can select By Single Data Point or By Dimension Value.
  Item	If the display method is By Single Data Point, Proportion is supported. If you set the Display Method parameter to By Dimension, you can set this parameter to Total or Proportion.
  Background color	Set the background color.
  Text	Sets the prompt text style.

  Note

  Switch to the layout of the mobile terminal. You can control whether to display tooltips on the mobile terminal.

• In the Series Settings section, configure the series. The following table describes the parameters.

  

  Note

  You must configure Display Name and Number Formatting in the Series Settings section only when Color Legend (Dim.) is used.

  Chart configuration items	Parameters
  Series	The series. You can specify a measure or dimension based on your business requirements.
  Line Style	You can change the line type. Note This parameter is unavailable in stacked areas and 100% stacked areas.
  Label Shape	Valid values: Circle, Hollow Circle, Diamond, and Hollow Diamond. Note This parameter is unavailable in stacked areas and 100% stacked areas.
  Display label	Set whether to display label, including label color and position.
  Show Boundary Values	Specifies whether to show the labels of the minimum and maximum values in the line chart. Note This parameter is unavailable in stacked areas and 100% stacked areas.

• In the Auxiliary Display section, configure the metric filter and thumbnail axes.

  

  Chart configuration items	Parameters
  Enable metric filtering	This parameter specifies whether to enable this parameter. After this parameter is enabled, the default metric field is selected.
  Show thumbnail axes	Set the display mode of the thumbnail axis.

Chart analysis configuration

Limits

When you create a line chart, you must specify Value Axis (Mea.), Category Axis (Dim.), and Color Legend (Dim.).

• You must specify at least one dimension for Category Axis (Dim.), such as report_date, province, or product_type.

• You must specify at least one measure for Value Axis (Mea.), such as order_number.

• You can specify only one dimension for Color Legend (Dim.), such as shipping_type.

  Note

  You can specify Color Legend (Dim.) only when Value Axis (Mea.) has one measure.

What to do next

• You can share your dashboard with others. For more information, see Share a dashboard.

• If you want to create a navigation menu for thematic analysis, you can integrate your dashboard into a business intelligence (BI) portal. For more information, see Create a BI portal.