We frequently report on our data by week. However, the DateTimeTrim function (in the Formula Tool and others) does not support this trim type.
Some workarounds have been posted that involve calculating the day of the week and then subtracting it out:
http://community.alteryx.com/t5/Data-Preparation-Blending/Summarize-data-by-the-week/td-p/6002
It would be very helpful to update DateTimeTrim as follows:
- Add a <trim type> of 'week'
- Add an optional parameter for <start of week>
- Default value: 0 (Week beginning Sunday)
- Other values: 1 (Week beginning Monday), 2 (Week beginning Tuesday), etc.