Query with Time Fields

One of the most common use cases in analytics is to run aggregate over time.

For example we might want to find the sum of order amount per day. This can be done by setting the fields field to createOn_DAY.

Query Variables

Similarily, we can find the sum of order amount per minute, amount per hour and other units by setting one of the following postfixes.

UnitPostFix (Sample Field)
By Minute_MINUTE (createdOn_MINUTE)
By Hour_HOUR (createdOn_HOUR)
By Day_DAY (createdOn_DAY)
By Week_WEEK (createdOn_WEEK)
By Month_MONTH (createdOn_MONTH)
By Year_YEAR (createdOn_YEAR)