Example queries

Sample queries to check out!

Example queries

  • Custom column cheatsheet

    The Mighty Cheatsheet  Welcome to the Mighty Cheatsheet! This guide will walk you through some of the different formulas and expressions ...

  • Difference between two dates

    Need the difference between two dates? No problem! ūüėä Use one of the following expressions. Trevor will calculate¬†DATE_1¬†-¬†DATE_2 and retu...

  • Top sales days

    In this article, we'll look at how to get:  The top sales day ever (both number of sales and revenue) The top sales day each mo...

  • If / then / else statements

    One of the functions you can perform in Trevor is called an 'if / then / else' statement (Also known as CASE if you're familiar with SQL)...