Here is a sample script
DECLARE FIELD DEFINITION TAGGED '$date'
first_month_of_year = 1
Year($1) As Year Tagged '$year',
Month($1) as Month Tagged '$month',
MonthName($1) as MonthName Tagged '$monthname',
Date($1) as Date Tagged ('$date', '$day'),
Week($1) as Week Tagged '$week',
WeekName($1) as WeekName Tagged '$weekname',
Weekday($1) as Weekday Tagged '$weekday',
DayNumberOfYear($1, first_month_of_year) as DayNumberOfYear
Year, Week, Weekday type drilldown as YearWeekDayName,
Year, Month, Date type collection as YearMonthDate;
DERIVE FIELDS FROM FIELDS "Claim Creation Date" USING Calendar;
here it is with the colored script coding for effect:
Earlier in the script i loaded a table with the name "Claim Creation Date"
"Claim Creation Date",
Here is a screen snippet of the result in the UI
Totally agree with the comment about controlling the names to be shorted of the derived fields. Feedback has been submitted.
Hi guys - here is the deal with the Groups syntax - that is reserved for a future feature - where it has been implemented in the back-end, but not yet exposed in the UI. There was a mistake adding that in the sample code in the documentation, and it is being updated. The Groups feature will be available in a future release - where it will automatically create the collection and cyclic groups for those specified fields.
Hope this helps.
Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.