QL charts. Overview

To create such charts, direct queries to the source are used. The query is run using the source database's SQL dialect, which helps expand visualization capabilities by using database-specific transactions.

Running a query does not create a separate Dataset object: a chart is generated on the fly and displayed in the preview panel.

Unlike dataset-based charts, the logic of a visualization area in QL charts favors queries against the source, that is, the visualization area only displays the data from the query.

QL charts:

  • Reduce database workload by using direct queries.
  • Only suitable for SELECT queries.
  • Enable the use of JOIN, GROUP BY, and SORT BY queries and aggregate functions in SQL queries.
  • Enable the parameterization of any part of a SQL query.
  • Support a limited set of visualizations types.

To create a QL chart, see the instructions.

See also