community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx Designer Ideas

Share your Designer product ideas - we're listening!
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE

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

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.

Meteor

Great idea!

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!

Alteryx
Alteryx
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.