Date filter batch macro

[NickKierstead]

I am trying to build a batch macro that updates a date filter that would trim a data set using a start and end date of. date field. The idea is to use the macro to batch process monthly statistics from a pool of historical data. I am not clear on how the table/input of batch start and end dates should be applied to the filter through an action. I have read all the literature and get the concept, but feel I am missing a few small critical details for this use case. Thanks, in advance, for any pointers.

[Felipe_Ribeir0]

Hi @NickKierstead 

Please see if the attached workflow is clear.

1) I made a dummy input with sales per date.

2)I wanna analyze the average sales per month using a batch macro (it is just an example, this could be done much more easily). So i created a calendar of dates to consider as a month, these start and end dates will be the parameters that gonna filter each iteration of my batch macro.

3)Inside my batch macro, i have a filter and i am going to update the filter parameters each iteration with the 2 dates of the previous step.

If the provided answer helped you to solve the problem/was correct, please accept it as a solution :)

Thanks.

[NickKierstead]

Thanks for the great example, it is very close to what I had, but I had the update string malformed and I forgot you could add two actions to one batch process. It's always the little stuff, thank you for the correction. I will try and apply it now.

[Felipe_Ribeir0]

Hi @NickKierstead 

It worked?