In the data configuration area of the visualization component, in addition to combining dimensions and metrics in the field parsing area, you can also process and process the data of the field itself, mainly including the following methods:
Aggregation Calculation
Aggregation calculation refers to changing the counting method of dimension columns or metric columns in the configuration of the visualization component. There are two types of aggregation calculation during the configuration, as follows:
Numerical Aggregation Calculation
When the selected field is a numerical type, the default statistical method is "sum" calculation, which can be changed through the form of custom calculation columns. The options include sum, average, count, distinct count, maximum value, minimum value, median, standard deviation, variance, and percentage, as shown in the following figure:
| Index | Name | Definition |
|---|---|---|
| 1 | Sum | The sum aggregation calculation method returns the total of all values in the field, ignoring null values |
| 2 | Average | The average aggregation calculation method returns the average value of all values in the field, ignoring null values |
| 3 | Count | The count aggregation calculation method returns the number of rows in the group, not counting null values |
| 4 | Deduplicate Count | Aggregation method for deduplicating count, returns the number of deleted duplicate rows in the group, does not count Null values |
| 5 | Maximum Value | Aggregation method for maximum value, returnsthe maximum value among all the records in the field |
| 6 | Minimum Value | Aggregation method for minimum value, returnsthe minimum value among all the records in the field |
| 7 | Median | Aggregation method for median value, returns the median value among all records in the field, ignoring Null values |
| 8 | Standard Deviation | Returns the statistical standard deviation of all values in the field for the entire population |
| 9 | Variance | Returns the statistical variance of all values in the field for the entire population |
| 10 | Proportion | Returns the percentage of each value in the field to the total value under the current calculation method, ignoring Null values. For example, proportion of sum, proportion of count |
Note: The visualization components that support multiple calculation methods are only available for custom queries, data tables, and analysis models-results tables. When using analysis models like "Event Analysis" or "Session Analysis" that already have predefined aggregation functions, the calculation method cannot be changed in order to maintain the semantic of the analysis model.
Aggregation Calculation
Specifies the calculation method for non-numeric fields, such as dates or text. By default, it is set to "Count", but it can be changed to "Distinct Count" or "Percentage".
| Count | Name | Explanation |
|---|---|---|
| 1 | Count | Returns the number of records in the group. Does not count null values. |
| 2 | Distinct Count | Returns the number of unique non-null values in the group. Does not count null values. |
| 3 | Porportion of Total Count | Returns the percentage of each value in the field to the total count. |
| 4 | Growth Rate |
|
Format Conversion
For the convenience of users to control the display of time and metrics on the chart, including date, number, and other data formats can be customized
Date Format
After selecting the field in the dimension and metric configuration area, select "Data Display Format" to enter the data formatting configuration popup. There are two display options:
- Display in the original format: default date format, displayed in the original state according to the storage format of the business model
- Display in the date format: custom date display, supports 17 date formats including "MM/dd/yyyy", "MM/dd/yyyy hh:mm:ss a", ........ "EEEEE, MMMM dd, yyyy". Below is a reference for all the formats:
Numeric Format
- Display in the original format: the default style of the numeric format is displayed in the original state according to the storage format of the business model, with thousands separators by default
- Display in the numeric format: default to display 2 decimal places, supports up to 10 decimal places, the data magnitude default selection is "None", supports "None", "Ten Thousand", "Million", "Ten Million", "Billion", "K", "M"
- Display in the percentage format: default to display 2 decimal places, supports up to 10 decimal places, as shown below:
Data Filtering
At the bottom of the data configuration area in each visualization component, there are data filtering configuration options, which are used to filter the data range of the current visualization component. Click "Add Filter Condition" to enter the data filtering drawer. You can configure the filtering rules for all fields through adding, and these filtering conditions can be selected as "AND" or "OR" relationships. See the following figure:
Data Sorting
When viewing data in visual components, you can sort by dimensions and metric values as a whole or by group. For example, you can view the overall sales performance of a company, or the sales performance of various regions within the company. Visual components in reports support two types of sorting:
Dimension Sorting
- The initial state of the dimension field is "No Sorting".
- When setting the sorting method on the "Dimension" field, you can choose to sort by the dimension itself or by the bound metric field to sort the groups of the current dimension.
- Supports setting sorting rules for multiple dimensions separately, and sort them in order.
- Since bar charts and stacked bar charts do not support sorting each cluster of bars in different orders, when sorting by sub-dimension, the actual sorting will be based on the values in the first group.
Metric Sorting
- The initial state of the metric field is "No Sorting".
- Sort all dimensions (including sub-dimensions) in order based on the aggregate calculation results of the metric.
- Ascending / descending order only depends on the aggregated results of the metric value.
- Group Ascending / Group Descending only applies within the groups of the dimension.