Skip to content
On this page

Create your first query

The Query is the main component of Insights. Consider query as an object that stores summarised data. It is used to create visualizations and dashboards.

Query List

Go to the Queries tab, to create a new query.

Query List

To create a query, you need to select a data source and a table.

New Query Dialog

Query Builder

Once you submit the form, you'll be redirected to Query Builder where you can create a query.

New Query

There are three main sections in the query builder:

  • Tables - This section is used to select a table from the data source. You get options to join tables here.
  • Dimensions & Metrics - This section is used to select dimensions and metrics. Dimensions are used to group data and metrics are used to calculate values.
  • Filters - This section is used to select filters. You can add simple or advanced filters here. You can even write logical expressions here.

Dimensions & Metrics

Since we have selected the Customers table, let's build a simple query to get the total number of customers. For this, we just need to add one metric that shows the count of records from the Customers table.

No. of Customers

Now, let's build a query to get the top 10 states with the highest number of customers.

Top 10 States


Filters are used to narrow down the data. Let's find out how many of our products weigh more than 1kg

Weight Filter

There are two types of filters:

  • Simple Filters

    • These filters are used to filter data based on standard operators.
    • Following operators are available in a simple filter
      • equals
      • not equals
      • greater than
      • less than
      • greater than equal to
      • less than equal to
      • one of
      • not one of
      • between
      • within
  • Expression Filters

    • You can write complex expressions that returns a boolean value to filter data.
    • You can use logical operators to combine multiple expression filters.
    • For eg., (`` = "CityA" && `Customer.state` = "StateB") || (`` != "CountryA")


Once you have created your summarised data, you can visualize it. Let's visualize the query that shows products that weigh more than 1kg. Since it represents a number, we can use the Number type to visualize it.

Number Card

For the query that shows the top 10 states with the highest number of customers, we can use the Bar type to visualize it.

Bar Chart

Released under the MIT License.