queries:start

Queries

Queries, sometimes called draw queries or referred as draw query language (DQL) is a simple querying feature which allows drawing graphics and connecting data.

  • Tables

    The draw query language is relational and structured in tables. This documentation is an overview of those tables. Fields are interpreted as a custom single table.

  • Functions

    This is an overview of all functions available within the DQL. Functions can be used to aggregate (sum, average ..) or do custom tranformations (ceiling, flooring, …)

  • Errors

    This is an overview of all known errors which can occur while executing queries or while saving a widget. Errors can be annoying but this documentation might help you fixing your problem.

  • Parameters

    This documentation is about parameters in the query language. A parameter is a value, such as an experiment channel which is being passed into the query (e.g. using the report parameters).

Syntax

The syntax of draw queries is almost the same as a SQL Query. If you are familiar if SQL, it is going to be very easy for you to learn writing draw queries.

A draw query consists of two parts:

  • The draw target specification, which determines what graphic receives the data.
  • The using body, which determines what data is going to be fetched.

A very simple draw query example would be:

draw pie-chart
using value, year(revenue.time) as label
from revenue