If you've built up a query using Trevor steps, but now you want to see what they look like in SQL, you can do that by 'exporting' the SQL...

If you want to sort your data by week (or month, day, etc.), first you need to group your data by week. To do this, add a summarize step ...

You can calculate the median of a column using the summarize step. Click the '+' button next to metrics and select 'median of' and then t...

When you are displaying your query in a dashboard or as a graph, you can add '%' or other pre- or post-text to your columns/rows in the c...

There are different ways that the data in your database can be stored. For example, we know the '3' is a number, but your database can re...

If you are using a pivot table graph to display your data, you can add a sum of column values and/or a sum of row values to your graph, l...

If you want to perform a calculation that brings the result as a new column in your query, or summarize horizontally, there are a couple ...

To group your data by something (date, location, any info you have in your database) you just need to use a Summarize step.  For example,...

You can invite guests, either external users or colleagues, to view your dashboards using our sharing modal:   When you invite a guest t...

You can add new categories to your Trevor that will appear on the left-hand side of your 'Saved Queries' page. When you save a query, you...

You'll see 'NULL' appear in column cells from time to time, when there is no data or no matching data available.  You can replace these '...

You can extract your email domain or email suffix directly from the column header like so:

If you want to change the column header, you can do this two ways:1. Via the steps element: Head to the add new step element on the left...

You can show / hide, or remove columns in two ways: 1. Via the column header: 2. Via the query steps: Go to columns and click the dropd...

1️⃣ Head to the add new step element on the left-hand side of your query builder and click columns. 2️⃣ Click reorder columns and rearra...

For this example, I'm going to find which product size (X) has the most sales (Y). 1️⃣ Head to the summarise step in the left-hand query ...

1️⃣ Head to the add new step element in your query builder, and select columns. 2️⃣ Select add new column from the drop down box. 3️⃣ Na...

1️⃣ Add a summarise step down the left-hand side of your query, and select the relevant date column as your dimension. 2️⃣ Choose the me...

Each datasource is associated with one Slack workspace. However, you can get around this by connecting your database as a new datasource ...

You can either click this link to watch a 26 second demo video, or follow the below instructions to filter a date range. 1️⃣ To filter be...

This is a quick guide to help you drill down data in your query: 1️⃣ Hover your mouse over the relevant arrow left of your query table. ...

There are two ways to filter your data: 1️⃣ Add a Filter step down the left-hand side of your query: 2️⃣ Hover over the chosen column ti...

Here's a step-by-step guide to building a query: Head to the Query builder on the left-hand side navigation menu (look for the rocketshi...

Here's a quick guide to creating a dashboard in Trevor.io: Click Dashboards on the left-hand side navigation menu (look for the bar char...

Simply add a Summarize step (in the Query Builder) to perform a group in Trevor  The Metrics are the aggregate operation(s) (e.g. count,...

Changing the time in your column to an am/pm format is straightforward, just follow the steps below or check out the video walkthrough. ...

To duplicate a query, all you need to do is: Go to the saved queries tab Search for the query you want to duplicate Click on the three d...

Count distinct, also sometimes referred to as 'count unique' is a function that allows you to count the distinct values of a particular c...

Creating an Entity Relationship Diagram in Trevor is super simple.  Go to the toolbar on the left-hand side, and click the compass icon. ...

Min The min function returns the smallest value in a specific column. If the column contains date values, the smallest value is the le...