Hello Team, I am trying to create a calculation logic in Alteryx, that dynamically calculates the last 6 weeks sales. Can someone help me with this? I don't have a date filed but a week filed that is in string data type.
Is it only one year of data? If you have multiple years of data how do you differentiate a week in 2023 vs 2022 without a date field?
what does your week field look like?
I have this sales data and they are grouped by weeks. I want to dynamically get the last 6 weeks data for 2022 and 2023 data. My difficulty is that I don't have a date field format and the week filed is a string format
If you have the week number you can convert it to a date, like the first day of the week and run off that.
@Bryth I have attached a workflow containing a number of potential solutions for you based on your use case and workflow complexity.
Personally, I like the Analytical App approach because it enables you to customize your data retrieval without having to go in to the workflow and change numerous tools.
Hope that helps out!