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.
- Reduce database workload by using direct queries.
- Only suitable for
- Enable the use of
GROUP BY, and
SORT BYqueries 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.