Skip to main content

What’s New

Qrvey 8.7
Version 8.7 of the Qrvey platform is now available to customers! This version includes new features including area charts, the ability to pivot and export data, as well as numerous bug fixes and performance improvements.
Learn More
Qrvey 8.6
Version 8.6 of the Qrvey platform is now available to customers. This version includes several new feature enhancements and performance improvements.
Learn More
Required Update for 8.5.1
Attention 8.5.1 customers: for any 8.5.1 instance deployed prior to 08/05/2024, an update is required to ensure you are running the latest images.
Learn More
Qrvey 8.5
Version 8.5 (LTS) of the Qrvey platform is now available to customers. This version includes several new features and performance improvements.
Learn More
End-of-life Schedule
We've added a new article that lists the features and endpoints that have been scheduled for deprecation. All features and endpoints will be supported for (1) year after the release date of the LTS version that contains the alternative.
Learn More
Version: 8.7

Date Grouping

Records that exist within dataset columns that are configured as a “Date” column type can be grouped into common date group buckets. Drag and drop a category field of type “Date” onto the Category shelf, click the three-dot menu and select Date Group. Choose the desired date group bucket and the chart will be redrawn with that date grouping applied.

date-group

The following date group buckets are available for Date fields within the Chart Builder:

TypeDescriptionDisplay FormatExample
YearYear component of the date value4-digit year2021
Quarter, YearQuarter of a specific year“Q” letter prefix, followed by a number between “1” and “4”, then a space and the 4-digit yearQ4 2021
Month, YearMonth of a specific year3-letter month prefix, followed by a space and then the 4-digit yearAug 2021
Week, YearWeek of a specific year“W” letter prefix, followed by a number between “1” and “52”, then a space and the 4-digit yearW26 2021
Full DateActual date valueFollows the corresponding setting for the field within the source dataset (e.g. “MM/DD/YYYY”)10/01/2021
Date, Hour*Hour of a specific dateFollows the corresponding setting for the field within the source dataset; minutes and seconds are ignored (e.g. “MM/DD/YYYY HH24:00:00”)10/01/2021 18:00:00
Date, Minute*Minute of a specific hour and dateFollows the corresponding setting for the field within the source dataset; seconds are ignored. (e.g. “MM/DD/YYYY HH24:MM:00”)10/01/2021 18:45:00
Date, Second*Second of a specific minute, hour and dateFollows the corresponding setting for the field within the source dataset. (e.g. “MM/DD/YYYY HH24:MM:SS”)10/01/2021 18:45:30
QuarterSpecific quarter of any/all years in the dataset; i.e. all data that falls within a specific quarter is grouped together for all years“Q” letter prefix, followed by a number between “1” and “4”Q3
MonthSpecific month of any/all years in the dataset; i.e. all data that falls within a specific month is grouped together for all years3-letter month prefixFeb
Day (Year)Specific day of any/all years in the dataset; i.e. all data that falls within a specific day of the year is grouped together for all years1, 2 or 3-digit day of the year. (1-365)330
Day (Month)Specific day of any/all months in the dataset; i.e. all data that falls within a specific day of the month is grouped together for all months1 or 2-digit day of the month(1-31)
Day (Week)Specific day of any/all weeks in the dataset; i.e. all data that falls within a specific day of the week is grouped together for all weeks3-letter day of week prefixMon
Hour*Specific hour of any/all days in the dataset; i.e. all data that falls within a specific hour of the day is grouped together for all days1 or 2-digit hour of the day(0-23)
Minute*Specific minute of any/all hours in the dataset; i.e. all data that falls within a specific minute of the hour is grouped together for all hours1 or 2-digit minute of the hour(0-59)
Second*Specific second of any/all minutes in the dataset; i.e. all data that falls within a specific second of the minute is grouped together for all minutes1 or 2-digit second of the minute(0-59)

*Not available if the date field does not contain hours, minutes and seconds.