Using the Charts tab you can view data in Bar, Pie, Scatter, and Sankey charts.
Bar Chart
A bar chart represents data with rectangular bars of lengths proportional to the value represented.
Bar chart parts:
| Part | Description |
|---|---|
| Horizontal | Categorical columns with data types, such as, Char, Varchar, and time. |
| Series | Column with numerical data types, such as, smallint, integer, numeric, and float. To add or remove a Series from a bar graph: From the Series menu, select Add or Delete, respectively. |
| Function | Aggregate function, such as, Average, sum, or count, which you can perform on specified numerical columns. |
| Chart Title | Title you give to chart. |
| Chart Title Position | Position (alignment) of chart title. |
| Data Label Position | Alignment of data label (to start, middle, or end of data). |
- Bar chart is not built if the values of X-Axis and Y-Axis are greater than +1.2e308.
- Bar chart is not built if the values of X-Axis and Y-Axis are less than -1.2e308
- Bar chart is empty if the values for a specific numerical column are all zero or NaN.
- Bar chart is not shown if an operation stops due to errors in calculation.
- Bar chart shows only 10000 records. If more records exist, a message appears.
- Bar chart is not built if the query results have more than 200000 records.
Stack option
When you select a bar chart with Stack option, and when the selected subcategory has unique values, the X axis displays stacks for each unique value. If there are duplicate values, the Stack adds up all unique values. Also, you can use aggregate functions Count and Sum while using Stack functionality in a bar chart.
Pie Chart
A pie chart (also called a circle chart) summarizes a set of nominal data or displays the different values of a given variable (for example, percentage distribution).
A pie chart is a circle divided into a series of segments. Each segment represents a particular category.
Pie chart parts:
| Part | Description |
|---|---|
| Name | Categorical column menu that contains the following categorical data types:
|
| Value | Numerical column menu that contains the following numerical data types:
|
| Series | Aggregate function that can be performed on the specified numerical columns. Aggregate functions:
|
| Pie Hole (Optional) | Visualizes inner hole or inner circle of pie chart, which you can change according to input given. |
| Pie Rotation (Optional) | Used to rotate pie chart. |
| Chart Title (Optional) | Used to provide title for chart visualization (Heading). |
| Chart Title Position (Optional) | Used to specify alignment of title heading (center, left, right). |
| Chart Label Position (Optional) | Used to provide alignment of the data labels of the chart (outside, inside or center). |
- Pie chart is not built if the values of X-Axis and Y-Axis are greater than +1.2e308.
- Pie chart is not built if the values of X-Axis and Y-Axis are less than -1.2e308
- Pie chart is empty if if the values for a specific numerical column are all zero or NaN.
- Pie chart is not shown if an operation stops due to errors in calculation.
- Null values in a column are not considered during operations and are eliminated from the Pie chart.
- Pie chart shows only 10000 records. If more records exist, a message appears.
- Pie chart is not built if there are more than 200000 records of a query result.
- By default, pie chart shows only 20 labels. You can select and add more labels.
Scatter Chart
A scatter chart, also called a scatter plot, shows the relationship between two variables. A scatter chart represents data points on a two-dimensional plane.
Scatter chart parts:
| Part | Description |
|---|---|
| X-Axis | X-Axis (Horizontal) is numerical columns menu that contains the following data types:
|
| Y-Axis | Y-Axis (Vertical) is numerical columns menu that contains the following data types:
|
| Category (Optional) | Categorical columns menu that contains the following data types:
|
| Chart Title (Optional) | Title for Scatter Chart. Default is X-Axis name & Y-Axis name. |
| Chart Title Position (Optional) | Position of chart title (LEFT, RIGHT or CENTER). Default is CENTER. |
- Scatter chart is not built if the values of X-Axis and Y-Axis are greater than +1.2e308.
- Scatter chart is not built if the values of X-Axis and Y-Axis are less than -1.2e308
- Scatter chart is empty if all values of X-Axis and Y-Axis are blank.
- Scatter chart does not support Visualization of entire data set.
Sankey Chart
A Sankey chart, also called a Sankey diagram, depicts a flow from one set of values to another. The things being connected are called source nodes and target nodes and the connections are called links. The weightage of links is called value. The higher the value, the more important the link.
Sankey chart parts:
| Source | X-Axis (Horizontal) is numerical categorical columns (from output of query run in Editor) menu that contains the following data types:
|
| Target | Categorical columns (from output of query run in Editor) menu that contains the following data types:
|
| Value (Optional) | Numerical columns (from output of query run in Editor) menu that contains the following data types:
By default, Sankey chart is drawn based on count of source-to-target connections. Columns with negative values are supported, but may hamper view of Sankey chart, so alert dialog box appears if you continue, but chart appears. If you do not continue, you can reselect column for value attribute. |
- Sankey chart does not display if the source and target columns are same, as this results in cyclic data formation. If different columns have cyclic data, an error displays. Fix and run the Sankey chart again.
- The visualization of entire data set is not supported in Sankey chart.
- If a column has negative values, the Sankey chart may appear clumsy and inferences cannot be drawn properly. A message Negative values are detected, and Sankey chart might not look proper. Would you like to continue? appears. If you want to continue, the Sankey chart is shown otherwise, or you can choose to reselect the inputs for source, target, and values.
- If there are more nodes and links, the Sankey chart may create a clumsy and unreadable view.
- Sankey chart supports numerical values with a precision up to 15 digits. Any values with more than 15 digits may change during calculations of the source to target link values.
Table Chart
A Table chart, as the name suggests, displays the columns in tabular format. You can select the columns and add aggregation function. The table chart always displays real-time data.