Hi there,
Having some issues currently with managing to use formulas/filters in Alteryx to get all of the previous month's data when ran (running on 5th Jan 23, would pull through all of Dec 22's data). This file pulls through all the previous months data so would include Oct22, Nov22, Dec 22 etc. And would like to just grab all of the data from the entire previous month from the "run month" if that makes sense please?
The example data format would be like below for simplicity, in practical use with more rows.
