Configuring a Pivot Chart with Line Visualization
Use the Pivot chart Line visualization to create timeline charts that track trends and changes over time. Line charts display data points connected by lines to help you identify patterns, trends, and anomalies in your asset or activity data.
Line charts can be configured in three ways:
- Single line - Display a single trend line based on aggregated data from a single metric.
- Multi-line -
- Multi-line with dimension segmentation - Create multiple lines to compare trends across different categories such as OS type, asset status, user, or activity type. Each unique value in your selected dimension creates a separate line.
- Multi-line with multi-measure comparison - Display multiple metrics on the same timeline to compare different measurements.
NoteWhen creating multi-line charts, you can segment by dimension or use multiple measures, but not both at the same time. See Configuring Multi-Line Timeline Pivot Charts.
Understanding Schema Options
When configuring a line chart, the Schema option determines whether the chart uses current data or historical snapshots:
- Latest Data - Uses data from the latest fetch. The chart aggregates data by a date field you select (such as "Last Seen" or "Created"), or by a number or ID field. See Using a Field That Isn't a Date on the X Axis.
- Data over time (snapshots) - Uses historical snapshots to show how data changes across multiple points in time. This option is only available for asset modules.
Modules with Limited Schema Options
Some modules don't support historical snapshots. For these modules, only the Latest Data option is available:
- Adapter Fetch History - Track adapter fetch activity, devices fetched, and fetch status over time
- Activity Logs - Track user and system activities, audit changes, and system events over time
- Audit - Monitor system and user audit events
- Security Findings - Track findings data over time
When you select these modules, the chart automatically uses Latest Data with a date field you select for the x-axis.
Configuring a Line Chart
This describes how to configure a single-line chart. To configure a multi-line chart, see Configuring Multi-Line Timeline Pivot Charts.
To configure a basic line chart:
-
On any editable dashboard, click Add Chart or edit an existing chart.
-
In the Name field, enter a descriptive name for the chart.
-
From the Widget list, select Pivot Chart.
-
Under Visualization, select Line.
-
Under Data, select a module and query that filters the data you want to track.
-
If the selected module supports multiple schema options, under Schema, select your preferred data source:
- Latest Data - Uses current data, aggregated by a date field you select
- Data over time (snapshots) - Uses historical snapshots (asset modules only)
-
Under Dimension Column, select the time field for the x-axis:
- Select a date field such as Start Time, Last Seen, Created, or Date
- Click the edit icon to configure time aggregation (Day, Week, Month, Quarter, or Year)
- With Latest Data, you can also select a number or ID field. Text fields aren't available. See Using a Field That Isn't a Date on the X Axis.
-
Under Dimension Row (optional):
- Leave empty for a single trend line
-
Under Metrics, select the field and calculation function:
- Count - Count the number of events
- Sum - Total of values
- Average - Calculate average values
- Median - Calculate the median value
-
Configure Calculation and Presentation settings, then click Save.
Using a Field That Isn't a Date on the X Axis
Use a number or ID field on the x-axis of a Line chart to show a measure for each value of the field, for example the number of findings for each year. The x-axis offers date, ID, and number fields. It doesn't offer text fields.
Permissions: To add a chart, you need the Dashboards > Charts > Add permission. To edit a chart, you need the Dashboards > Charts > Edit permission. To view the chart, you need the Dashboards > View permission.
To use a field that isn't a date on the x-axis:
- On a dashboard, click Add Chart and select Pivot Chart.
- Select a module and, if necessary, a query.
- Select the Line view.
- In Schema, select Latest data.
- In the Dimension Column section, open Axis and select a field. The field can be a date, a number, or an ID.
- In the Metrics section, select a measure and its Function.
- Click Save.
- A date field keeps the time axis. The date label formats and the period options stay the same.
- A field that isn't a date creates a category axis. Each value of the field is one point on the x-axis.
- The points appear in the order of the values. Numbers sort by number, so 2 comes before 10.
- A chart that you saved with a text field on the x-axis keeps that field. When you edit the chart, the field list still shows that field, but you can't select another text field. The points of a text field sort alphabetically and ignore case.
- A Line chart whose x-axis isn't a date doesn't show the date range under the chart.
- When the category labels don't fit flat, the chart tilts them or cuts them with an ellipsis (β¦). Hover over a cut label to show its full name.
- On a category axis, the date label formats and the period labels don't apply. Target lines, points, and point values work as on a date axis.
- The tooltip and the data table name the x-axis by the field name, or by its Display label if you set one. On a date axis, they show "Date" or "Period".
- Segmented lines, which use a field in Dimension Row, and lines with more than one measure also work on a category axis. They sort by value.
- The same chart appears in the same order in report PDFs.
- Data over time (snapshots) doesn't change. Its x-axis always shows the snapshot dates.
Example: A Latest data Line chart on Security Findings uses a year field as the x-axis and a count measure. The chart shows one point for each year, from the earliest year to the latest.
Working with Line Charts
Once you create the chart:
- Hover over data points - View detailed information in a tooltip
- Click on data points - Open the relevant module page filtered to show the specific events
- Export Data to CSV - Select Export Data to CSV from the chart menu
Examples
Example 1: Single Line Chart - Total Adapter Fetch Count
Track the total number of adapter fetch events over time using Adapter Fetch History. This module uses Latest Data only.
- Create a line chart named "Total Adapter Fetches - 30 Days"
- Select Adapter Fetch History as the module
- Under Dimension Column, select Start Time with Day aggregation
- Leave Dimension Row empty (for a single line)
- Under Metrics, select a count field with Count function
- Set calculation to show the last 30 days
- Save the chart
The chart displays a single line showing the total number of fetch events per day over 30 days.
Updated 10 days ago
