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