To create a new query, go to the queries list and click on "New query" on the top right.
On the query editing page you can start by adding a name, description and tags (1)
Next is the area where the SQL query can be written (2); the open scheme explorer button allows the DB tables browser to see all available tables and fields (3).
At the bottom of this area, you can see a preview of the query results.
Click the Run button to execute the query. Whenever you make a change, you need to click this button.
After creating the query, you can add the next step, which is the arrow down at (4)
This next step can be one of the following categories:
Choice of the type of visualization for the query result
The scripter step, which can run Ruby/Python/C# code on the query result
SQL - which can allow the creation of an additional query
Date filter - will be presented as part of the actual dashboard and allow the user to filter the query result by time frame. The date filter defines a 'statr_date' and an 'end_date' which are used in the query, for example:
will give results for the last 7 days.
Query filter - will be presented for the user and will allow to filter query rows by any of the parameters (Make sure to place the filter above the table step in the query building window)
You can see a preview of the query at the end of the page as it will appear on the dashboard.