Managing Charts

Note: This feature is available in Enterprise, AWS, Team editions only.

Table of contents

• Creating Charts In SQL Editor
• Creating Charts In Data Editor
• Creating Charts In Grouping Panel
• Editing Chart Settings
  • Setting Axis X
  • Setting Axis Y

Use CloudBeaver's Charts feature to transform your SELECT queries into colorized charts. You can visualize data in Bar and Pie formats.

Create a chart directly in the SQL Editor, Data Editor or Grouping Panel. It's a quick and simple way to bring your data to life.

Creating Charts In SQL Editor

Visualising large data sets makes your analysis faster and more precise. Charts let you grasp important details quickly.

To create a chart in the SQL Editor, click the Charts button on the left vertical toolbar of the query results area. Your data instantly transforms into a visual representation.

Creating Charts In Data Editor

Charts are a powerful tool for visualising structured analytical data, such as those stored in Views.

If you want to create a chart for a table, it requires some preparation. First, sort and apply various filters to the table's columns to structure the data. These changes directly affect the appearance of the chart, enabling you to customize the visual representation to fit your needs.

To build a chart using the Data Editor, simply press the Charts button located in the left vertical toolbar. A chart based on your structured data will be created.

Note: By default, the data for Y-axis is taken from the first column of the table containing numeric values.

Creating Charts In Grouping Panel

The Charts feature also works with analytical tools like the Grouping Panel. When building a chart for a table that contains grouping results for one or more columns, you can easily switch the source data for the X and Y axes by changing the columns in the Charts Editor.

To create a chart in the Grouping Panel, press the Charts button on the left vertical toolbar.

Editing Chart Settings

To edit the chart settings, click Settings button in the bottom menu. The settings dialog will then appear, allowing you to make adjustments.

The following chart settings can be adjusted:

Setting Axis X

• In the Column drop down list of available columns select a column whose data will be used on X-axis of the bar chart. Make sure you choose unique columns for X-axis.
• Define a user-friendly axis name in the Label text field.

Setting Axis Y

• In the Column drop down list of available columns, select a column whose data will be used on Y-axis of the bar chart.
  Note, that only numeric and string columns can be used for Y-axis.
• Define a user-friendly axis name in the Label text field.