Example queries

Sample queries to check out!

Example queries

  • Attendance at UEFA Women's Euro 2022 Competition

    We looked at data from the UEFA Women's Euro 2022 Competition to see which days of the week had the best attendance against the stadium c...

  • Custom column cheatsheet

    The Mighty CheatsheetĀ  Important: certain formulas / expressions can be a little tricky to write. If you have a question or need help, ju...

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