Hello Everyone,
I am new to Alteryx and was wondering if I could ask for help with a workflow I have.
I pull from SQL Server to get the orders we have processed from each supplier. I have put together a workflow that gives me a base for what I would like to accomplish. However, I'm stumped by how to add a column in that calculates the difference in orders between Column A and Column B, B being the following week and will be dynamic as more weeks are added.
Also, I am having a little trouble with returning the correct week number, as you can see below (2021-00). I used DateTimeFormat([Act Arr CST],"%Y") +'-'+ DateTimeFormat([Act Arr CST],"%W").
If anyone has any suggestions, can you please provide them?
I believe this is as per design.
%W This returns the week number, as 00 – 53, with the beginning of weeks as Monday
We can make it as starting from 01 though.