Alteryx Designer

Find answers, ask questions, and share expertise about Alteryx Designer.
Register for the upcoming Live Community Q&A Session - and don't forget to submit your questions for @DeanS regarding the future role of analytics here.
SOLVED

Rolling up Weekends Numbers to Friday

Highlighted
8 - Asteroid

Hello-

Is there a way we can roll up Saturday and Sunday numbers to Friday ? Following is the issue I am trying to solve .Thank you .

 

Rolling_Weekends.PNG 

Highlighted
Alteryx Certified Partner
Hey @MD2050

You could update your workday column with the formula tool like so:

If workday in ('Saturday', 'Sunday') then 'Friday' else workday endif

Then use the summarize tool to sum value grouped by workday

Neil
Highlighted
8 - Asteroid

Hello Neil-

Thank you for reply. Please see attached my workflow , the issue is to retain the Friday's Date meaning 3/4,3/10 should be merged into 3/9. I cannot achieve that by Summarize tool. If you do a sum by Workday then yes I will get only Mon,Tues,Wed,Thu and Fri .

Thank you.

Highlighted
7 - Meteor

Write a formula,

If Day = Saturday, Date minus 1

If Sunday, Date minus 2

 

And Summarize by Date.

Highlighted
8 - Asteroid

Hello @subbarao-

Thank you for your suggestion, it worked . Please find in attached the updated workflow for reference. 

 

Thank You.

Highlighted
Alteryx Certified Partner
Hey @MD2050,

No problem, you can join back to your original data (after the summarize) using workday as the key field... This will give you the results you need
Labels