Dezbor
← Back to Docs
🔍

How to Query your data

Build Your Dashboard

query

Unleashing the power of your data begins with understanding how to query it effectively. Here's how you can do it with dezbor's user-friendly query builder.

Using Query Builder

Dezbor's Query Builder makes it easy to build queries, even if you have little to no knowledge of SQL. It uses a visual interface allowing you to select and combine different fields.

Follow these steps to create a new data query:

  1. Select your data source: Navigate to your dashboard and click on 'QueryBuilder'. Select the database or Google Sheets file you wish to retrieve data from.
  2. Select your fields: Specify the fields you wish to pull data from. Simply drag and drop them into the Query Builder.
  3. Set conditions (Optional): Refine your query by applying conditions or filters in the 'where' section. For example, select data where the date is after 2021 or where a text field contains a certain word.
  4. Preview your results: Click on 'Execute Query' to run your query and preview the data.
  5. Use or Save your query: If you're happy with the data, click 'Save'. This data can now be utilized in your dashboard.

Editing a Query

To edit a previously made query, go to the QueryBuilder, select the query you wish to edit, make your changes, and save the updated query.

SQL Mode

For those familiar with SQL, you have the option to switch to SQL mode. You can manually input SQL queries to retrieve your data.

Navigating data query in dezbor is an effortless and intuitive experience. Start querying and uncover important insights hidden in your data.

How to Query your data - Dezbor Docs