ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now

Alteryx Designer Ideas

Share your Designer 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
16 - Nebula
16 - Nebula

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.