The SQL query visualization chart feature enables swift and efficient visualization and analysis of query results. It supports various chart types, including line charts, column charts, bar charts, and pie charts. This topic outlines scenarios for different chart types to assist you in selecting the most suitable chart for data visualization and presentation.
Line chart
Line charts are ideal for displaying data trends over consistent time intervals, such as tracking sales changes over time and forecasting future trends.
Legend | Data elements |
|
|
icon to sort data elements in ascending, descending, or no particular order. When sorting is applied to both the x-axis and y-axis, the x-axis sorting has priority.
icon to choose the aggregation method for data. The default method for numeric fields is sum, with options for sum, average, or count; for non-numeric fields, the default is count, which is the only available option.Column chart
Column charts are excellent for comparing differences across data groups and illustrating variations over time.
Legend | Data elements |
|
|
Bar chart
Bar charts, similar to column charts, are effective for comparing the magnitude and differences between data points in a horizontal layout.
Legend | Data elements |
|
|
Pie chart
Pie charts effectively represent the proportion of each segment to the overall total in a dataset.
Legend | Data elements |
|
|
