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 in 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...

Max The max function returns the highest value in a specific column. If the column contains date values, the highest value is the most...

Average The average function calculates the average of the values in a specific column. Examples To see the average price paid per...

Sum The sum function sums the values in a specific column. For example, you may want to find out your total sales or cumulative sum of...

How do I count rows in Trevor? The count function counts the total number of rows containing each of the distinct values in a specific c...