AUTO(date expression)

Returns a date using the most suitable date grouping period (DAY, WEEK, MONTH and etc.) automatically based on differences between the minimum and maximum of date expressions in the data set.

date expression: Date calculation created using date functions, data fields or constants.

Use cases

Spent time on tasks grouped by period selected by system automatically

Compare the sum of spent hours for completed tasks.

Source: Tasks

Time tracking stats for tasks of the building super hero suit

Completed OnTaskHours SpentFeature
03 Jan 2018 10:13 AMCreate a steel helmet to protect head19Protective Suit
20 Jan 2018 04:08 PMCreate a chest protection from steel45Protective Suit
05 Feb 2018 11:34 AMAsk agency to create fancy identity for new super hero30Design
09 Feb 2018 02:11 PMInstall super hero logo on body and helmet2Protective Suit
09 Feb 2018 02:11 PMPut on gloves with nice color2Protective Suit
12 Feb 2018 09:01 PMAsk Hulk to push in head5Combat Testing
01 Mar 2018 06:45 PMAsk Hulk to push in chest5Combat Testing


Y: SUM([Hours Spent])

X: AUTO([Completed On])

LABEL: AUTO([Completed On])


AUTO(Completed On)SUM(Hours Spent)
3 Jan 201819
20 Jan 201845
5 Feb 201830
9 Feb 20184
12 Feb 20185
1 Mar 20185