Table of Contents

Time Period Queries

Using Time Period queries, you can simplify the process of creating time-consuming, complex queries. With these keywords, Tellius brings more flexibility for time-based search queries. With the following type of keywords, you can ask straightforward questions in Search.

  • yearly
  • quarterly
  • monthly
  • since/from a specific time period

Query using "yearly" keyword

  1. Show me the average price for 2015 compared to 2017

Calculates average price with yearly resolution and data filtered for 2015 and 2017.

Query using "quarterly" keyword

  1. 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.
  2. Show total revenue for Q1 2020

Query using "monthly" keyword

  1. Show the total Profit for April 2017 compared to April 2018

Calculates total Profit with monthly resolution and data filtered for April 2017 and 2018.

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

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

  1. Show total monthly sales for Jan 2011 to Dec 2011

Calculates the total sales with monthly resolution from Jan 2011 to Dec 2011.)

Query using "since/from" keyword

Since and From translate to the >= operator, which gets applied to the date/time value that follows. 

  1. Show me property since 2009
Date operators Since and From for search queries

More such examples:

  • Show total sales monthly for Q1 2011 to Q4 2012
  • Show total sales monthly for 2011 to 2013
  • Show me products purchased since June 2017
  • Show me inventory by region since 3/2/2021
  • Profit in the United States since Feb 3, 2021

Query for immediate preceding time period

Users can compare a chosen period against its immediate predecessor to gain insights on short-term performance, identify emerging trends and monitor current growth against recent historical data.

The query can be used for days, weeks, months, years, and quarters.

Example: "Show me sales of last 2 months vs the prior 2 months"

Other variations:

  • Show me sales of last n [days/weeks/months] this year [vs/compared to] prior n [days/weeks/months] last year
  • Show me sales of last n [days/weeks/months] [vs/compared to] the preceding period
  • Show me sales of last n [weeks/months] [vs/compared to] the prior n [weeks/months]

Query for YoY time period comparison

Users can assess the performance against the same time period from the previous year to understand seasonal trends, benchmark against the previous year's performance, and measure yearly growth/decline in a more granular manner.

The query can be used for days, weeks, months, years, and quarters.

Example: "Show me sales by segment for the last 4 weeks this year vs 4 weeks last year"

Other variations:

  • Show me sales for the last x [days/weeks/months/quarters] this year [vs/compared to] last year
  • Show me sales for the last x [days/weeks/months/quarters] this year [vs/compared to] x days last year 
  • Show me sales by segment for the last x [days/weeks/months/quarters] this year [vs/compared to] x [days/weeks/months/quarters] last year

Did we help you?

Percentage Queries

Live Query

Contact