Once your SQL query returns the columns you’re interested in, you can now choose how you want the data displayed by selecting a visualization chart type.

There are four visualization chart types from which to choose:

• Line chart
• Area chart
• Bar chart
• Pie chart
• Table
• Bubble chart
• Scatter plot

To render visualization output,

1. Select a Chart Type from the drop-down menu in the Visualization region. The Table chart type is selected by default.
2. Set the visualization parameters:

   For Line, Bar, or Area Chart Type

   Choose the desired metrics you want to use for the X 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 choose to include a chart Legend and Y-axis Title.

   For a Table Chart Type

   1. Choose the columns you want to include. Click in the Columns region to display a drop-down list of columns returned by your SQL query and select a column. When the first column is added, the visualization is rendered.
      
      
      
      
   2. Continue adding columns until the rendered visualization displays the precise information you’re interested in. If desired, you can select the All Columns option to include all columns returned by your query. To remove columns from the rendered visualization, click the “x” to the right of a column name in the Columns region.