Time Period Queries

Hardik Chheda Updated by Hardik Chheda

Time Period queries are the queries by which you can retrieve the information for a particular date and time range. For example for last year, from January 2020 to April 2020, for Q1 and Q2 of 2020, etc.

Samples

  1. Show me the average price for 2015 compared to 2017
    Calculates average price with yearly resolution and data filtered for 2015 and 2017.
  2. Show total Profit for Q2 2017 compared to Q1 2018
    Calculates total Profit with quarterly resolution and data filtered for different quarters in different years.
  3. Show total Profit for April 2017 compared to April 2018
    Calculates total Profit with monthly resolution and data filtered for April 2017 and 2018.
  4. Show percentage Profit for Jan 2013 compared to Feb 2013 across all dates
    Calculates percentage Profit with monthly resolution and data filtered for Jan and Feb 2013, but the percentage is calculated across the complete time range.
  5. Show total Profit for last 3 months compared to last 3 months of 2018
    Calculates total Profit with monthly resolution and data filtered for (last 3 months from May) Feb, March and April of current year and 2018.

How did we do?

Percentage Queries

Live Query

Contact