- 29 Aug 2023
- 6 Minutes to read
- Updated on 29 Aug 2023
- 6 Minutes to read
The Pivot chart provides flexible data segmentation and presentation to support complex data analysis. Use the Pivot chart to segment asset fields from different points of view by measuring the asset field values on a desired asset field segmentation and create a visualization with multiple chart representation options such as bar charts, line charts, pie charts, and more.
Configure the Pivot chart by selecting options in the various configuration sections. The available options in each section reflect the configured settings in previous sections.
Work through the following sections to configure a Pivot chart:
For clarity, the following sections demonstrate the creation of a simple Pivot chart, SaaS Application Activity.
Use General settings to define the name of the chart, add an optional description, and set the type of chart widget.
- Chart title - Enter a descriptive title for the chart.
- Description - Enter an optional description about what the chart shows, the data and/or query it uses, etc.
- Widget - Select the chart widget. For the Advanced Pivot Chart, select Pivot Chart.
In this example, the chart title is SaaS Application Activity. There is an appropriate description and Pivot Chart is selected as the widget.
The Pivot chart allows you to select from a range of chart types.
Select the chart type that best represents the data you want to see:
- Bar chart - A standard bar chart.
- Pie chart - A standard pie chart.
- Stacked bar chart - Displays bars divided into segments to represent different asset groups or other segmentation.
- Line chart - A standard line chart.
For this example, the chart type of Stacked bar chart is selected segment the data by a particular field. A total of all found assets appears at the end of the bar, while each stacked section of the bar represents a segment of data. The following sections will configure the other parameters to select the various data, metrics and calculations that will describe what data to display and how.
Use the Data settings to select the query that determines the data that is displayed on the chart.
Under Module, select an asset module and a query. You can also click + Add Query at the bottom of the list to create a new query. See Creating Queries with the Query Wizard for more about creating queries.
Under Schema, select whether to use current or historical data in the chart:
- Latest data - Use data from the latest fetch. Aggregates data by the asset Date field.
- Data over time (snapshots) - Use data from historical snapshots.
Historical Date - Only available when Latest data is selected. Toggle on to choose a specific fixed date or a date relative to the current date. See Viewing Query Results from a Historical Date.
For this example, SaaS Applications is selected as the module and the query is left empty to include all SaaS applications. This will return data about all SaaS applications. In addition, under Schema, Latest data is selected to use data from the most recent fetch.
Select the data segmentation to be represented on the axis. Data from the query in the Data section will be segmented according to the field selected here.
Under Axis, select an adapter and field.
Click to filter the data returned by the selected query. When a filter is applied, a red dot appears on the filter icon. To clear the filter, click the icon, and then Clear and Save.
Click to assign a custom name to the axis. This is useful when you want a more representative name than the field name itself. When a custom name is applied, a red dot appears on the pencil icon. To clear the custom name, click the icon, and then Clear and Save.
Click to add another axis dimension. If the selected chart type doesn't support multiple dimensions, this will be disabled.
For this example, the field Name is selected. This means that data will be segmented by SaaS application name and and the axis label adjacent to each bar will be the name of the corresponding SaaS application name. The chart below shows axis labels for the SaaS applications: Zoom, ServiceNow, Okta, and Azure.
The values represented by the bars and that appear to the right of them are determined by the next two settings, Metrics and Calculation.
Select the values within the Dimensions selected above that you want to count or total in the chart.
- Select an adapter and a field. Some chart types allow you to select multiple measures.
- Click to assign a custom name to the measure. This is useful when you want a more representative name than the field name itself. When a custom name is applied, a red dot appears on the pencil icon. To clear the custom name, click the icon, and then Clear and Save.
- Click to add another measure. If the selected chart type doesn't support multiple measures, this will be disabled.
For this example, the screen below shows five different user statuses selected as the measures in this example. These will return the number of users per status per SaaS application as selected in the Dimensions section above. The chart will display the users per status for each application. Each bar in the chart represents a SaaS application and will be segmented to display the number of users per user account status.
Select the calculation function you want. The available functions depends on the field type. The selected function will apply to all Measures in the Metrics section.
For this example, the Sum function is selected. This will calculate the total number of users per SaaS application, segmented by user status.
You can mouse over a chart bar to see the segmentation displayed in a tooltip with the total number of users of each status.
The following table describes the calculation functions available for each field type.
|Sum||*||Totals the field value|
|Average||*||Calculates the average|
|Count||*||Number of assets|
|Count True||*||Number of returned True values|
|Count False||*||Number of returned False values|
Compare results - Display a comparison between the latest data and data from a previous date. See Comparing Today's Query Results to a Previous Date.
Add percentage - When enabled, calculates and shows the percentage of the segments compared to one of these values:
- From Selected Query - Calculates the percentage of the total of the field selected in the module field.
- From Custom Input - Enter a custom value. The segment's percentage is calculated as a fraction of the entered value.
Use the Presentation options to configure how the data in the chart is presented.
Select a default sort method for the bars or slices or lines:
- Sort by value or Sort by name - Sort by the values or by the name of the value.
- Ascending or Descending - Sort in ascending or descending order.
Additional Presentation settings:
- Set asset count threshold colors - Toggle on to set threshold colors. See Setting Asset Count Threshold Colors.
- Show title - Toggle on to show the title of the chart from the Chart title field.
- Show totals - Toggle on to show totals.