Date filter-Refreshing biweekly

[VahidGoli]

Hi All,

I have a data source which continuously stores cost data. I need to start filtering the Date field for a certain period of time (which is two weeks) and then continue for every two weeks.

If we assume I have different types of costs in a two-week period (I used Summarize tool to group the cost types), I need to first filter the date field to a certain initial period of two weeks. Then I need the next period of two weeks which actually just consider the next two weeks and not including the initial two weeks, and keep continuing this kind of refreshing date filter biweekly.

Would you please guide me on how I can achieve this?

Thank you in advance for your guidance.

[atcodedog05]

Hi @VahidGoli 

This is kind of confusing to me but here 2 things what the solution might be.

1st approach : consider period based on current date

2nd approach : iterative macro https://community.alteryx.com/t5/Videos/Build-Your-First-Iterative-Macro/td-p/55565

Hope this helps 🙂

[Qiu]

@VahidGoli 
Agree with @VahidGoli , I either not quite get what you need.

But prepared a simple flow to check the Date and allocate it to a Bi-Week Account.

[VahidGoli]

@Qiu, thanks for your answer. Although it wasn't what I wanted, you gave me greater insight, and I built the workflow based on that. It is very much appreciated.

Kind regards,

Vahid

[Qiu]

@VahidGoli 
Sorry did not perfectly match your need, but glad helped a bit.