Quick BI:Combination chart

Prerequisites

A dashboard is created. For more information, see Create a dashboard.

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.

  • An area 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.

• Benefits

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

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

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

• Example of combination charts

Configure a combination chart

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

   • In the measure list, double-click the order_amt measure. You can also drag this measure to the Primary Measures field.

   • In the measure list, double-click the profit_amt measure. You can also drag this measure to the Secondary Measures field.

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

2. Click Update to create the LBS heat map.

   

3. (Optional) If you only need to view the data of a certain number of cities, you can set filters to filter the required data.

4. Auto Refresh

   After you select Auto Refresh, the system refreshes the bubble chart as scheduled. For example, if you select Auto Refresh, enter 5, and then select Minutes, the system refreshes the bubble chart every 5 minutes.

Configure the style of a combination chart

• You can change the chart style on the Fields tab of the Chart Design page.

  In this example, select Line as the chart type for profit_amt in the Secondary Measures field.

  You can also move your pointer over Standard to change the stacking mode of the chart.

• The following section describes how to configure the styles of an LBS heat map. For information about the common style settings of charts, see Configure the chart title.

  You can enter a keyword in the search box at the top of the configuration section to search for configuration items. You can also click Expand /Collapse All Categories in the right-side chart.

  

• In the drawing area, set the chart style.

  

  Chart configuration items	Descriptions of parameters
  Color Settings	You can set the color for a combination chart.
  Display Direction	You can set the Chart Direction parameter to Horizontal or Vertical.
  Alignment	If the chart orientation is Vertical, you can set the chart alignment mode to Align Left or Align Right.
  Line	You can set the line type to Curve or Line, Marked Points, and Nulls.
  Column	You can set the width of the column.
  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 Selected Items.

• 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.

  

  Parameter	Parameter
  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	Specify whether to display labels on the x-axis, axis label display rules, and text style.
  	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.
  	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	Specifies whether to display Axis Title and Unit.
  	Show Value	Specifies whether to display labels on the left Y-axis. You can also set the Label, Scale Range, and Axis Label formats.
  	Show Scale	Specifies whether to show scales on the 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.

  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 on the Left Y-axis tab.

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

  

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

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

  

  Chart configuration items	Descriptions of parameters
  Full Display	Set whether to display full label.
  Text	Sets the label text style.

• In the Tooltip section, configure the tooltip mode.

  

  Chart configuration items	Descriptions of parameters
  Display mode	The display mode of the prompt information. You can select By Single Data Point or By Dimension Value.
  Background color	Set the background color.
  Text	Sets the prompt text style.

• 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 if Color Legend (Dim.) is used.

  Chart configuration items	Descriptions of parameters
  Series	The series. You can specify a measure or dimension based on your business requirements.
  Display label	Specify whether to display label, including the 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 area charts and 100% stacked area charts.

• In the Auxiliary Display section, configure the display mode of the thumbnail axis.

  

Chart analysis configuration

Limits

When you create a combination chart, you must specify Primary Measures, Secondary Measures, Category Axis (Dim.), and Color Legend (Dim.).

• You must specify at least one measure for Primary Measures and at least one measure for Secondary Measures, such as order_amt or profit_amt.

• You must specify at least one dimension for Category Axis (Dim.), such as order_date(year).

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

  Note

  You can specify Color Legend (Dim.) only when Primary Measures or Secondary Measures has one measure.

What to do next

• You can share a dashboard with specific users. 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.