This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Upgrading Server to version 22.1? We’ve enabled the faster AMP engine by default. Read about how these system settings changes might affect you.
We’re aware of an intermittent issue with our My Alteryx login and are actively working to have the issue corrected. If you run into an error when logging in, please try clearing all cookies or accessing the community on a different browser. Thank you for your patience!
Anyone have any ideas on how to solve this? I’m open to new suggestions.
the problem I’m trying to solve: I need to pro-rate hours that overlap two months in any given week.
example: if you have 35 estimated hours for week ending 4/3/2021, then 20 of the hours should move to the prior period, 3/27/2021, since 4 of the days falls into March. the remaining 15 hours should stay in the current period.
You're getting the duplicated rows after the join because your month calendar has records for multiple days that correspond to each week ending. If you use a summarize after your select you can reduce this to a unique list of original and new dates
For your prorating, use a formula tool based on the difference between the original and start of month dates for current month and new and start of month for the previous month