Documentation

Supported date/time hierarchy column names

Date/time columns should be named according to the following convention to be correctly interpreted by the visual - 'X unit', where:

'X' is a whole number, followed by a space;
'unit' is a valid date/time unit from the list below.


Here is the full list of the supported date/time units and numbers of units:

milliseconds:

'1 ms', 'ms', 'millisecond', 'milliseconds',
'5 ms', '5 milliseconds',
'10 ms', '10 milliseconds',
'20 ms', '20 milliseconds',
'50 ms', '50 milliseconds',
'100 ms', '100 milliseconds',
'250 ms', '250 milliseconds',
'500 ms', '500 milliseconds'


seconds:

'1 s', 'sec', 'second', 'seconds',
'2 s', '2 seconds',
'3 s', '3 seconds',
'4 s', '4 seconds',
'5 s', '5 seconds',
'10 s', '10 seconds',
'20 s', '20 seconds',
'30 s', '30 seconds'


minutes:

'1 m', 'min', 'minute', 'minutes',
'2 m', '2 minutes',
'3 m', '3 minutes',
'4 m', '4 minutes',
'5 m', '5 minutes',
'10 m', '10 minutes',
'15 m', '15 minutes',
'20 m', '20 minutes',
'30 m', '30 minutes'


hours:

'1 h', 'hour', 'hours',
'2 h', '2 hours',
'3 h', '3 hours',
'4 h', '4 hours',
'6 h', '6 hours',
'12 h', '12 hours'


days:

'1 d', 'day', 'days', 'dayofmonth',
'2 d', '2 days',
'3 d', '3 days',
'4 d', '4 days',
'5 d', '5 days',
'6 d', '6 days',
'10 d', '10 days',
'14 d', '14 days',
'15 d', '15 days'


weeks:

'1 w', '1 week', 'week',
'2 w', '2 weeks',
'3 w', '3 weeks',
'4 w', '4 weeks',
'5 w', '5 weeks',
'6 w', '6 weeks',
'8 w', '8 weeks',
'10 w', '10 weeks',
'12 w', '12 weeks',
'16 w', '16 weeks',
'24 w', '24 weeks'


months:

'1 M', 'mon', 'month', 'months',
'3 M', '3 months', 'quarter', 'quarters',
'2 M', '2 months',
'4 M', '4 months',
'6 M', '6 months'


years:

'1 y', 'year', 'years',
'2 y', '2 years',
'3 y', '3 years',
'5 y', '5 years',
'10 y', '10 years', 'decade'


If any of the above is not clear, does not work as expected even if you followed the setup step-by-step, or you would like us to add even more units or configuration options, please contact [email protected]