Stand with Ukraine flag
Try it now Pricing
Trendz Analytics
Community Edition Professional Edition Cloud Edge PE Edge IoT Gateway License Server Trendz Analytics Mobile Application PE Mobile Application MQTT Broker
Documentation > Key concepts > Group by time
Getting Started
Guides Installation

Grouping and Aggregation data by time

In most cases data is grouped by time interval - by hour, day, week, month, etc. You should use Date field from left panel and drag and drop it the X-axis section.

Default function for Date aggregation is RAW - it means that user can control what is an aggregation interval using Group By combobox near Time Range picker. System will take full range from Time Range picker and devide it into smaller intervals depending on selected value. Latter, selected aggregation function applied for each interval. Allowed values for Group By field are:

  • Month
  • Week
  • Day
  • Hour
  • Minute

image

You can have more control on date intervals by selecting other available Date aggregation options:

  • RAW,
  • MINUTE
  • HOUR
  • FULL_HOUR - ‘2020-03-01 23’
  • DAY - day of the week
  • DATE - day of the month
  • FULL_DATE - ‘2020-03-01’
  • START_OF_WEEK - 2020-03-01
  • WEEK_OF_YEAR - numeric week of the year
  • WEEK_OF_MONTH - numeric week of the month
  • MONTH
  • QUARTER
  • YEAR
  • YEARMONTH - ‘2020-Feb’