Dynamic filtering with different parameters

[Joker_Hazard]

Hey everyone.

I am trying to dynamically filter a date based on some previous formulas validation. Here's a visual example:

The user has to input this data (which represents Dates) every day, which is dauting. So the idea is to replace it dynamically.

I created a formula that checks the date and get the previous date, which is the one that should be inputted in the filter.

As you can see, the column "Date -1" Should always replace the content within the filter. How to make it automatic?

thanks!

[DataNath · Accepted solution]

Unless I'm reading/understanding this wrong, couldn't you just use:

[Data] = [Date -1]

As your last line? Instead of the manually typed date.

[DanM]

@Joker_Hazard 

The solution here is to create a batch macro. You can feed your new date and your data into the batch macro where within the macro you can update the filter tool. Here's some resources on batch macros.

https://community.alteryx.com/t5/Interactive-Lessons/tkb-p/interactive-lessons/label-name/Macros

[Joker_Hazard · Accepted solution]

Yeah, I've had the exact same thought as you afterwards. It did work. 

I was thinking of a way complicated model, like using analytical apps or Macros. 

[Joker_Hazard]

Hey Dan. Macros for me are very deliciated. I have been using Alteryx for 4 years already I never have I ever tried to learn macros. I don't see a worth use case for them.

I know I'm utterly wrong on that, however could you clarify why macros are important if Alteryx can run workflows "just like one" or use for example multirow formulas for example.

Thank you very much 

I will take some time to learn those tools.