Using Trevor

Everything you need to know to become a data superstar with Trevor.io.

😎 Product updates

🧐 How do I...?

  • Cohort analysis

    A cohort analysis breaks your users / products / actions into groups based on some shared characteristic. You can then perform analyses o...

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

  • Get highest value

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

  • Get the average

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

  • Count unique values

    Count unique values The count unique values function counts the number of unique values in a specific column. It's particularly usef...

  • Sum of values

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

See all 7 articles

🥷 SQL in Trevor.io

  • Writing raw SQL

    Yes you can! Simply: Head to the Query Builder tab.  Click Start New Query button.  Select the SQL option.  You can even write SQL, and...

  • SQL snippets in Trevor

    If you're used to writing SQL, it'll take you just a few minutes to get used to Trevor.io's interface.  In Trevor.io, you build queries ...

  • Count distinct values

    In Trevor.io, you can use the Summarize step to perform aggregate functions. To count distinct values, simply: Add a Summarize step Clic...

🙊 Troubleshooting

  • Speed up slow queries

    Here are a some things you can do to make your queries run faster: 1️⃣ Reduce the size of your data set by adding an early filter.  Try a...

  • Query suddenly slow

    If a query that usually runs very quickly suddenly takes much longer, then it's possible your database is dealing with some other load.  ...

  • Duplicate rows

    If you've notice the presence of duplicate rows, or multiple rows for one line item in your query, don't worry! Usually this is caused by...

🔗 Intro to joins

  • What is a join?

    Joining refers to combining rows from two or more database tables. Imagine a simple database with just 2 tables: A Customers table An...

  • Types of join

    In this post, the left table (or table A), means the table you're starting from. The right table (or table B), means the table you're...

  • Database table relationships

    Three types of relationship exist between related tables.  1️⃣ One-to-One One record in a table is associated with one record, and only o...