How to Work with Aggregated Dates Using R

This article describes how to go from an aggregated Date/Time variable...

...to a dynamic R variable where you can change the category labels:

Requirements

A Date/Time variable. In this example, we have a date variable called StartDate, which has been aggregated to 1 Quarter.

1. Hover over any variable in the Data Sources and click + > Custom Code > R > Nominal.

2. Paste the below in the code panel:

attr(StartDate,"QDate")

This code uses the attr function to pull the aggregated QDate label from our StartDate variable.

3. Update the Name and Label on the Properties under General > General.

4. Go to Data > Attributes > Values & Labels and update any labels as required.

6. Press OK.

Note, when your source data updates, this variable will update accordingly, and any new aggregated categories will automatically be added.