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 your:Ā  Top sales day ever (both number of sales and revenue) Top sales day each month...

  • If / then / else statements

    One of the functions you can perform in Trevor is called an 'if / then / else' statement. To do this you need to: Click 'columns' andĀ ad...