An indicator trend chart shows the latest values of multiple metrics, the aggregated values of the metrics within a period, and the changes of these metrics over a period. This topic describes how to add data to an indicator trend chart and configure the style of the indicator trend chart.
Prerequisites
A dashboard is created. For more information, see Create a dashboard.
Overview
Scenarios
In specific scenarios, you need to observe the changes of metrics to see whether exceptions occur in your business. An indicator trend chart is used to display the values of metrics and the trend of value changes over a period.
Benefits
Calculation capability: You can configure the advanced calculation features with a few clicks. This helps you compare values with historical values.
Data visualization: You can add logos to the chart and configure settings, such as the background, font size, and color of the chart.
Other capabilities: You can add remarks, such as words and metrics. You can also add hyperlinks to link metrics to other platforms.
Renderings
Create a chart
On the Field tab, select dimensions and measures based on your business requirements.
In the Dimension list, double-click shipping_date(day). You can also drag this dimension to the Date (Dimensions) section.
In the measure list, double-click order_number, order_amt, shipping_cost, and profit_amt. You can also drag these measures to the Indicator (Measures) section.
Set the Default Metric Value parameter and click Update. Then, the system automatically updates the chart.
Latest Date Data: displays the latest value within the specified period on each metric card.
If you select Latest Date Data, the value of the metric card is the data of the last day (20161230).
Stage Summary Data: displays the aggregated value within the specified period on each metric card.
If you select Staged Data, the value of the metric card is the data aggregated within the interval (20161201 to 20161230).
Configure the chart style
This section describes how to configure the style of an indicator trend chart. For more information about the general styles 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 Trend Chart section, configure the Trend Chart Type, View Chart, and Color Settings parameters.
Chart configuration items
Description
Trend Chart Type
Valid values: Show Trend Chart and Metric Trend Chart.
Switch between visualized charts
You can switch between line charts, area chart lines, and column chart lines.
Color Settings
You can set the color of the metric trend chart.
Line Type
(Line Chart /area chart Scenario)
Supports Curves and Lines.
Label Shape
(Line Graph Scene)
Set whether to display marker points and customize the shape of marker points.
process NULL values
(Line drawing /area chart scene)
The following methods are supported: Direct Crossing, Set to 0, Disconnect, and Line Break.
Date Duration
The default value is 30. Unit: days.
Display Legend
Set whether to show the legend.
NoteThe Layout for Multiple Indicators parameter is displayed only if the Show Trend by Date parameter is set to Overall Trend.
In the Indicator Layout section, configure the layout style of the indicator block.
If you set Trend Chart Type to Show Trend Chart, perform the following steps:
Chart configuration items
Description
Metric Block Group
Options: Displayed in One Line and Displayed in Multiple Lines. If you select Displayed in One Line, the slider appears, and you can adjust the slider to view all indicators in one row. If you select Displayed in Multiple Lines, indicators are displayed in multiple rows. You can also set the number of metric blocks per row on the metric trend chart.
NoteThis option is available only when you turn on the Trend Chart switch.
Background color
Set the Background Color parameter for the indicator block. You can select Light or Solid Color.
Indicator Block Spacing
Set the spacing between metric blocks.
Indicator Block Height
Set the height of the indicator block. You can adjust the height by defining the distance between the indicator content and the indicator block.
Interaction between a metric and a trend chart
Options:
Single Choice: Only the trend of one measure can be displayed in the indicator trend chart.
Multiple Choice: The trend of two or more measures can be displayed in the indicator trend chart.
NoteThis option is available only when you turn on the Trend Chart switch.
If you set the Trend Chart Type parameter to Metrics with Small Trend Chart, set the following parameters:
Chart configuration items
Description
Metric Block Group
You can specify the number of metric blocks per row on the metric trend chart.
NoteThis option is available only when you turn on the Trend Chart switch.
Metric Block Separation
Set Indicator Block to Undelimited, line separator delimited, or Background Fill delimited.
line separator color
Sets the color of the indicator block line separator.
NoteYou need to configure this option only if the indicator block delimited selection line separator.
Background color
The color of the Background Fill parameter. You can select Monochrome or Multicolor. You can select a color for Monochrome or Multicolor.
NoteYou need to configure this option only when you select Background Fill for Indicator Block Separation.
Indicator Block Spacing
Set the spacing between metric blocks.
NoteYou need to configure this option only when you select Background Fill for Indicator Block Separation.
In the Indicator Content configuration items, set Content Position and Display Mode, Font Size Style, and Indicator Modifier Style.
Chart configuration items
Description
Content position in indicator block
Set the position of the content in the indicator block. You can select Left or Center. In the Horizontal Center section, set Alignment to Left and Center.
Indicator Value Rows
Moderate and Compact are supported.
Field Description Icon
Supports Material and the color of the field description.
Font Size
Select Enable Font Size. After you enable Font Size, you can specify the Dimension Name, Primary Metric Name, Primary Metric Value, Secondary Metric Name, and Secondary Metric Value Font Size, Color, Bold, and Italic parameters.
NoteIn the Metrics /Measures section, the first metric is the primary metric. The rest measures are secondary metrics.
Indicator Modifier Chart
Select Show Main Indicator Decorated Chart. After you select Show, you can set Decorated Chart Position, Color, Decorated Chart Type, and Graphic Style.
You can select Left or Top in the Modifier Position field.
You can use Material or Image Field to modify the figure type.
The Image Field parameter is available only when the dataset contains Image Field and the field type is.
When you select a material, you can use the material icon or upload a local image.
NoteOnly images in the PNG, JPG, and GIF formats are supported. The maximum size is 1 MB.
You can select Transparently or Solid Color for Pattern Format.
In the Axes section, set the x-axis, left, and right Y-axis styles.
Parameter
Parameter
Dual Y-Axis
Set whether to display secondary Y-axis.
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
Specifies whether to show values on the X-axis.
Show Scale
Sets whether tick marks are displayed on the x-axis.
Show Axis
Set the display axis style, including line type, line weight, and color.
Show Network Lines
Specifies whether to show gridlines on the X-axis, including the line style, line width, and color of the X-axis.
Left Y-axis
Show Left Y-Axis
Set whether to display the left Y-axis.
Y-axis Scale Flip
You can set the flip y-axis scale value.
Show Title and Unit
Set whether to show Axis Title and Unit.
Show Value
Specifies whether to show values on the left y-axis.
Show Scale
Specifies whether to show scales on the axis.
Maximum and Minimum Values
You can configure the maximum and minimum values only when the Trend Chart Type parameter is set to Show Trend Chart.
If and only if the custom maximum value is greater than the maximum value of the data itself and the minimum value is less than the minimum value of the data itself, the custom maximum value is available. Otherwise, the custom maximum value does not take effect.
NoteIf you select Default, the minimum and maximum values are automatically displayed on the axis. If you clear Default, you can manually configure the minimum and maximum values 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.
Y-axis Label Settings
The display formats for labels on the axis. Options: AutoFit, Customer, and Manual.
If you have configured a unit of measure for a metric, you must specify the y-axis axis labels in the same format as the unit of measure. You can set Display Format to Auto Fit and select Single Select, Follow Measure data format configuration items.
Show Network Lines
Specifies whether to show gridlines on the left y-axis. If you select Gridlines, you can specify the line style, line width, and color of gridlines.
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.
Support custom interval set by step size or by equal number
NoteRight Y-axis is required only when Display secondary Y-axis is selected. The parameter configuration is the same as that of Left Y-axis.
In the label configuration items, set the label display style.
Chart configuration items
Description
Full Display
If you select this check box, all label are displayed.
Text
Sets the label text style.
In the Tooltip section, configure the following parameters: background color, text style,
NoteYou can select by total and proportion only if you select Multiple in the Indicator Layout section of the Metrics and Trend Chart Association Interaction page. If you set the Display Method parameter to By Single Data Point, you can select by proportion. If you set the Display Method parameter to By Dimension Value, you can select by total and proportion.
You can select secondary metrics only when you turn on Show Secondary Metrics.
Switch to the layout of the mobile terminal. You can control whether to display tooltips on the mobile terminal.
In the Series Settings section, set the label, the maximum value, and the prefix and suffix of metric data.
Chart configuration items
Description
Series
Select a measure that you added to the Indicator (Measures) section.
Prefix and Suffix for Data Value
The prefix and suffix for the value of a measure in the indicator trend chart.
In the Conditional Formatting section, configure conditional formats for measures.
Chart configuration items
Description
Series
Select a measure that you added to the Indicator (Measures) section.
Shortcut Style
Select marker icons and font colors.
Custom Style
Customize text, icon styles, marker icons, range values, and font colors.
Synchronize Style To
Replicate the conditional formatting settings of a measure to other measures.
In the Auxiliary Display section, set Enable Metric Filtering and configure a metric trend chart.
Chart analysis configuration
Parameter | Data type | Description |
Data interaction | Linkage | If the data that you want to analyze belongs to different charts or tables, you can configure this feature to associate the charts and tables, and then analyze the data. For more information, see Linkage. |
Hyperlink | If the data that you want to analyze belongs to different dashboards, you can configure this feature to associate the dashboards, and then analyze the data. You can set the Hyperlink parameter to Parameter or External Link. For more information, see Redirect. | |
Advanced Settings | Display Secondary Indicator | If you select Display Secondary Indicator, you can configure the display modes of secondary metrics. For more information, see the "Display secondary indicators" section in Latest cross table. After you enable this feature, you can specify the content, display formats, prefixes, and suffixes of secondary metrics. Example:
|
Metric Analysis | Gridlines | An auxiliary line can be used to show the difference between the value of a measure and the reference value indicated by the auxiliary line. The reference value can be a fixed value or a calculated value. You can use the following calculated values: average, maximum, minimum, and median. For more information, see the "Auxiliary line" section in Metric analysis. |
Label | - | If data in a chart is abnormal or requires additional attention, you can highlight the data or add icons, notes, or data points. This helps you detect exceptions and perform subsequent operations. For more information, see Label. |
Limits
When you create an indicator trend chart, you must specify measures and dimensions in the Indicator (Measures) and Date (Dimensions) sections.
You can specify only one dimension in the Date (Dimensions) section, such as shipping_date(day).
You must specify at least one measure in the Indicator (Measures) section, such as order_number or order_amt.
What to do next
You can share your dashboards 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.