Create an Intuitive Visualization

Once your SQL query returns the columns you’re interested in, select how you want the data displayed in the Visualization region.

In the Chart type menu, select one of the available visualization types: Line Chart, Area Chart, Bar Chart, Pie Chart, Scatter Chart, Bubble Chart, Single Value, or Table. Table is selected by default.

To render visualization output:

1. Select a chart type from the Chart type menu in the Visualization region.
2. Set the visualization parameters for the selected chart type.
   • For Line Chart, Bar Chart, or Area Chart, select the metrics to use in the X axis and Y axis. For additional clarity when plotting multiple databases, you can use the Color By menu to increase visual differentiation. The Color By option also acts as a grouping (splits into individual series) based on the field selected. You can also configure chart options such as Legend and Y-axis Title, when available.
   • For Table, click in the Columns field and select the columns returned by your SQL query that you want to display. When the first column is added, the visualization is rendered. Continue adding columns until the table displays the required information. To include all returned columns, select All columns. To remove a column, click the x next to the column name.