Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!
The Product Idea boards have gotten an update to better integrate them within our Product team's idea cycle! However this update does have a few unique behaviors, if you have any questions about them check out our FAQ.

Alteryx Designer Desktop Ideas

Share your Designer Desktop product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines

DateTimeTrim Function - Add Week Trimming

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.

 

 

 

4 Comments
jdunkerley79
ACE Emeritus
ACE Emeritus

I have a 'WeekStart' function in my function library: https://github.com/jdunkerley/AlteryxFormulaAddOns

 

At moment rounds to Sunday but easy to expand to include a weekday parameter. Happy to send you if would work for you.

jgolden
7 - Meteor

Great idea!

bkornell1
6 - Meteoroid

Just had a chance to check out your function library, jdunkerley79. It's extremely helpful, and it includes other functions (like IFNULL) that are not native to Alteryx. 

 

Thanks for sharing it!

RachelW
Alteryx Alumni (Retired)
Status changed to: Comments Requested

Thanks for submitting this idea! I am currently looking into additional functions we should add to the expression editor. If you have any ideas for other functions please let me know the function and the category (existing or new). 

 

Thanks again for submitting an idea to the Ideas forum.