Date and Time Functions

Arcadia has several built-in transformations for date and time that can be applied before rendering visual charts.

To use a date and time functions, follow these steps.

  1. When creating or editing a visual, determine for which field variable you must adjust date or time presentation.

    The shelves that support date and time functions depend on the visual type, and are typically available for X and Y axes, Measures, Dimensions, Colors, and Tooltips.

  2. Click the icon to the right of the variable.

  3. In the dropdown, click Date/Time Functions.
  4. From the Date/Time Functions menu, select one of the following options:

    • Date returns the value of to_date([field]).
    • Year returns the value of year([field]).
    • Month returns the value of month([field]).
    • Year and Month Count returns the value of the following expression:

      concat(cast(year([field]) as string), '-', if(month([field]) < 10, '0', ''), cast(month([field]) as string)) as 'month of year'
    • Day of Month returns the value of dayofmonth([field]).
    • Day of Year returns the value of dayofyear([field]).
    • Day of Week returns the value of dayofweek([field]).
    • Remove Function removes all of the above.
  5. Click Refresh Visual.