Updated at: 2022-12-09 03:49:50
It presents aggregated data in a tabular format to help identify Top N type of aggregation, with specific steps as follows:
1. Click Visualization > Data Table to select data sources. You can filter out the required data sources by selecting Log Group or Saved Search;
2. Enter the Data Table page, and configure parameters as follows:
1) Metrics - Y axis: One or multiple metric aggregation types can be added;
• Aggregation: Select the type of aggregation for the y-axis: Count (default), Avg, Sum, Median, Min, Max, Unique Count, Percentiles, Percentile Ranks, and TopN;
• Conversion of Units: Set the conversion from original units to target units, and you can enable/disable this function;
• Custom Tag: Set the axis name displayed on the Y axis
2) Buckets - X axis: Classify bucket aggregation on field values according to the selected fields:
• Select Bucket Type: You can select Split Rows or Split Tables;
• Aggregation: Available types: Date Histogram, Histogram, Range, Date Range, IPv4 Range, Terms, Filters, Significant Terms, and Geohash;
• Field: Set the fields to be aggregated;
• Custom Tag: Set the axis name displayed on the X axis
3. After completing the above configuration, click the
button at the top left to check the visual view on the right, as follows:

4. For the generated chart, you can also switch to the Option to set the final column statistics values, and the summary functions include: Sum, Avg, Max, Min, and Count as follows:

5. After visual view configuration, click Save to complete the current visual view creation.
1. Click Visualization > Data Table to select data sources. You can filter out the required data sources by selecting Log Group or Saved Search;
2. Enter the Data Table page, and configure parameters as follows:

• Aggregation: Select the type of aggregation for the y-axis: Count (default), Avg, Sum, Median, Min, Max, Unique Count, Percentiles, Percentile Ranks, and TopN;
• Conversion of Units: Set the conversion from original units to target units, and you can enable/disable this function;
• Custom Tag: Set the axis name displayed on the Y axis
2) Buckets - X axis: Classify bucket aggregation on field values according to the selected fields:
• Select Bucket Type: You can select Split Rows or Split Tables;
• Aggregation: Available types: Date Histogram, Histogram, Range, Date Range, IPv4 Range, Terms, Filters, Significant Terms, and Geohash;
• Field: Set the fields to be aggregated;
• Custom Tag: Set the axis name displayed on the X axis
3. After completing the above configuration, click the


4. For the generated chart, you can also switch to the Option to set the final column statistics values, and the summary functions include: Sum, Avg, Max, Min, and Count as follows:

5. After visual view configuration, click Save to complete the current visual view creation.
< Previous:
Next: >