A serial chart visualizes one or more series of data points along a category (x) axis and a value (y) axis and is especially useful when plotting temporal data such as metrics or comparing the relationship of two fields. Serial charts can be configured to visualize data as a line, bar, or scatter chart. You can also invert the axis to display the data in a horizontal or vertical format. To add a serial chart to an analysis view, complete these steps:
- Access edit mode for the analysis view to which you want to add a serial chart.
- Click Add Element > Serial Chart.
The Select Data Expression dialog box appears with a list of the analysis view's data expressions.
- Click New Data Expression or continue with step 8 to use an existing expression.
The Edit Data Expression dialog box appears.
- Provide a name for the expression in the Name text box.
- Use the expression builder to choose the type of data that you want to display in the chart.
For example, to build an expression that contains CPU utilization metrics for all components, do the following:
- Click Resource and choose Components.
- Click Join next to Components and choose Metrics.
The join appears under Components.
- Click Where next to Metrics.
The clause appears under Metrics.
- Click the Select a field drop-down arrow and choose Identifier.
- Leave the operator set to is.
- Click the Select drop-down arrow and choose cpu_utilized.
Tip:
To provide your own value, click Source type: Choose value and click Enter value.
- Click Join next to Metrics and choose Metrics Data.
The join appears under Metrics.
- Optionally, click Test to test the expression.
Data that matches the expression appears on the tabs next to the expression.
- Click Done.
The expression appears in the Data Expressions list.
Tip:
You can duplicate an expression and use it as a base for similar types of data by clicking Duplicate , edit an expression by clicking Edit , and delete an expression by clicking Delete .
- Choose an expression in the list and click Select.
The Serial Chart dialog box appears.
- Click the Category Field drop-down arrow and choose the field that you want to use for the category.
For example, to group CPU utilization values by the time at which they were observed, choose Observed At.
Tip:
Click the tabs under the chart's preview to view the data returned by the expression.
- Click the Statistic Type drop-down arrow and choose the type of statistic that you want to show in the chart.
For example, to show an average of the CPU utilization values over the course of the view's chosen time range, choose Average.
- Click the Statistic Field drop-down arrow and choose the field that contains the data that you want to evaluate using the chosen Statistic Type setting.
For example, to show the value of the CPU utilized metric, choose Value.
- Optionally, click Split and click the Split by Field drop-down arrow to choose the field that you want to use to split the data.
For example, to split the data by component name, choose Name.
Tip:
To turn off Split by Field, click Disable split by .
- Optionally, click Add Date Filter and choose a date field on the Date Filter Field drop-down menu to allow the chart to be filtered by the analysis view's time range options.
Note:
If the field you chose for Category Field is a datetime field, date filtering is automatically enabled.
Tip:
To turn off date filtering, click Disable date filter .
- Click Chart from the side of the dialog box.
The Chart tab appears.
- Choose a chart type next to Type.
The chart preview is updated to match your chosen chart options.
- If you chose Bar as the Type setting, optionally, turn on the Stacked toggle button to create a stacked bar chart.
- Choose the chart's orientation next to Orientation.
- Optionally, provide a title for the chart's category axis in the Category Axis Title text box.
- Optionally, provide a title for the chart's statistic axis in the Statistic Axis Title text box.
- Optionally, turn on the Legend toggle button to add a legend to the chart and choose a Position setting.
- Click General from the side of the dialog box.
The General tab appears.
- Optionally, provide a title for the chart in the Title text box.
- Optionally, provide a description for the chart in the Description text box.
- Click Done.
The chart appears in the analysis view.
- Optionally, hover over the chart and use the buttons to perform the following actions:
- Drag Move to move the chart to a new location in the analysis view.
- Click Configure to edit the chart.
- Click Duplicate to duplicate the chart.
- Click Delete to delete the chart.
- Drag Resize to change the size of the chart as necessary.
- When you're finished adding elements to the analysis view, click Save.
Tip:
You can also click the Save drop-down arrow and click Save As to save the analysis view with a new name and description.