AUTO
AUTO([Date])Syntax
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 On | Task | Hours Spent | Feature |
|---|---|---|---|
| 03 Jan 2018 10:13 AM | Create a steel helmet to protect head | 19 | Protective Suit |
| 20 Jan 2018 04:08 PM | Create a chest protection from steel | 45 | Protective Suit |
| 05 Feb 2018 11:34 AM | Ask agency to create fancy identity for new super hero | 30 | Design |
| 09 Feb 2018 02:11 PM | Install super hero logo on body and helmet | 2 | Protective Suit |
| 09 Feb 2018 02:11 PM | Put on gloves with nice color | 2 | Protective Suit |
| 12 Feb 2018 09:01 PM | Ask Hulk to push in head | 5 | Combat Testing |
| 01 Mar 2018 06:45 PM | Ask Hulk to push in chest | 5 | Combat Testing |
Chart SCATTERPLOT
Y: SUM([Hours Spent])
X: AUTO([Completed On])
LABEL: AUTO([Completed On])
| AUTO(Completed On) | SUM(Hours Spent) |
|---|---|
| 3 Jan 2018 | 19 |
| 20 Jan 2018 | 45 |
| 5 Feb 2018 | 30 |
| 9 Feb 2018 | 4 |
| 12 Feb 2018 | 5 |
| 1 Mar 2018 | 5 |