Filter Previous Week Per Day Any Day This Week

[Steph]

Hello!

I ran my build last Monday and it worked, all of the data from the previous week was filtered correctly.

However, today (Wednesday) when I ran the build it included Monday, Tuesday and Wednesday of this week. Have attached the 2 workflows here.

I would like my build to be able to filter previous week's daily data regardless of the day I ran the build in the current week.

I tried and I just can't make it work.

Appreciate the help please.

[atcodedog05 · Accepted solution]

Hi @Steph 

Your ranges didnt seem right can you try this workflow. I am treating Monday as first day of the week.

Hope this helps : )

[SPetrie · Accepted solution]

Just to toss this out as an alternative answer if you dont want to use a switch statement. I have the Sunday and Monday versions in the workflow.

 

 

[Steph]

Hi @atcodedog05
Hi @SPetrie 

All flows are working, my build got the much needed improvement!

Thank you so much! 😊 

[atcodedog05]

Happy to help : ) @Steph 

Cheers and have a nice day!