Skip to content

Managing charts

Note

This feature is available in Lite, Enterprise, Ultimate and Team editions only.

The default grid view of query results may look unremarkable. Use DBeaver's Charts feature to transform your SELECT queries into colorized charts. You can visualize data in Bar, Line, or 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

Visualizing 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 visualizing 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, simply press the Charts button on the left vertical toolbar

Editing Chart Settings

To edit the chart settings, right-click inside the chart area to open the chart's context menu, and then select the Settings option. The Chart Editor will appear, allowing you to make adjustments.

The following chart settings can be adjusted:

Setting Axis X

  • choose a column for the X-axis from the Column dropdown

    Tip

    Make sure you choose unique columns for X-axis.

  • name the X-axis in the Label field

  • optionally, use Order to sort X-axis values in Ascending or Descending order

    Note

    If both X and Y sorting are enabled, the Y-axis sorting takes precedence over the X-axis sorting.

Setting Axis Y

  • choose a column for the Y-axis from the Column dropdown

    Note

    Only numeric and string columns can be used for Y-axis.

  • label the Y-axis in the Label field

  • for advanced customization, you can use the Parse value with regex option. Regular expressions (regex) allow you to filter, match, or manipulate the column values according to specific patterns or criteria. This functionality offers precise control over the data displayed on the Y-axis, enabling you to create more refined visual representations. If you're unfamiliar with regular expressions, the Regular Expressions Tutorial provides comprehensive guidance and examples.

  • optionally, use Order to sort Y-axis values in Ascending or Descending order

    Note

    If both X and Y sorting are enabled, the Y-axis sorting takes precedence over the X-axis sorting.

Options

You can also set the following chart options:

Setting Description
Sample count Maximum number of columns used to build the chart
Row count Maximum number of rows used to build the chart
Sample function Aggregate multiple rows into a single summary value displayed on the Y axis
AVG - Average value
SUM - Sum of all values
FIRST - First value
LAST - Last value
COUNT - Total count of values
MIN - Minimum value
MAX - Maximum value
Chart type Choose how to visualize the data: Bar, Line, or Pie

Copying to clipboard

You can copy a chart to a clipboard by selecting the Copy to clipboard option in the chart's context menu.

Exporting Charts

You can export a chart into PNG format by selecting the Save as... option in the chart's context menu.

Printing Charts

You can print a chart by selecting the Print... option in the chart's context menu.

Zooming and Viewing Options

In the chart's context menu, you will find additional options for interacting with the chart:

  • Zoom in: Enlarge the view of the chart.
  • Zoom out: Reduce the view of the chart.
  • Zoom Reset: Return to the default zoom level.
  • View as: Change the visualization format of the chart. A submenu will appear, allowing you to select between Bar, Line, or Pie formats.