🧐 How do I...?

  • Convert Trevor steps to SQL

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

  • Sort by week

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

  • How to get the median

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

  • Display as a percentage

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

  • Change column type

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

  • Include rowcounts

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

  • Summarize as a column

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

  • Group data by month

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

  • Invite guests to your dashboard

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

  • Add a category

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

  • Replace NULL

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

  • Extract email suffix

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

  • Rename columns

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

  • Show / hide columns

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

  • Reorder columns

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

  • Find the X that has the most Y

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

  • Multiply the value of two (or more!) columns

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

  • Create a date series

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

  • Change the Slack workspace for an alert / dashboard

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

  • Filter dates between a specific range

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

  • Drill down

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

  • Filter my data

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

  • Create a query

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

  • Create a dashboard

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

  • How to perform a 'group by' in Trevor

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

  • Get time in am/pm format

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

  • Duplicate a query

    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

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

  • Create an ER Diagram

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

  • Get lowest value

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