topic Re: Filter to return previous Friday until current day. in Alteryx Designer Desktop Discussions

Filter to return previous Friday until current day.

Fred22 — Thu, 24 May 2018 04:52:10 GMT

My data is comprised of tickets from the beginning of time. It is updated each day but we only want to return the previous Friday until the current day. For example: Today is Monday February 12th. When my flow is ran it should only return data from Friday February 9th until now. The date column is in a format of Month Day Year: 2/12/2018.

Thank you!

Re: Filter to return previous Friday until current day.

john_miller9 — Mon, 12 Feb 2018 18:04:49 GMT

@Fred22

This will give you the date of the previous Friday for each date in your file, and then filter to those records since the previous Friday. This workflow keeps the past 8 days if Today is a Friday. You can adjust that in the filter though if you expect to only keep Today's records if it is a Friday by lowering to 7.

Re: Filter to return previous Friday until current day.

Fred22 — Tue, 13 Feb 2018 13:26:54 GMT

Hi John,

Thank you for the input. This looks like it would work perfectly but I am running Alteryx 10.6 and it won't let me open your file. Anyway you could send the file in a different format or the formulas?

Thanks again!

Re: Filter to return previous Friday until current day.

john_miller9 — Tue, 13 Feb 2018 15:15:04 GMT

Sure - see the workflow and input attached

Re: Filter to return previous Friday until current day.

Fred22 — Tue, 13 Feb 2018 15:50:35 GMT

Hi John,

When trying to open alteryx it says there was an error because the document was created by a more recent version of this application and cannot be read.

Any suggestions?

Re: Filter to return previous Friday until current day.

john_miller9 — Tue, 13 Feb 2018 15:55:16 GMT

See the images of my formula and filter tool configurations attached.

Re: Filter to return previous Friday until current day.

Fred22 — Tue, 13 Feb 2018 16:01:41 GMT

Great thank you! Let me test this and see if it returns what I am looking for.

Re: Filter to return previous Friday until current day.

Fred22 — Tue, 13 Feb 2018 17:03:16 GMT

Hi John,

I almost have it working. My only issue I am running into is I need to pull everything since last Friday including Friday. With your formula and filter I am getting everything since Saturday Feb 10th. If it can include Feb 9th too it will be solved.

Any suggestions? Thank you very much.

Re: Filter to return previous Friday until current day.

john_miller9 — Tue, 13 Feb 2018 17:06:59 GMT

Ok - try this in the formula tool for Previous Friday

DateTimeAdd([Date],
	Switch(DateTimeFormat([Date],'%a'),0,
		'Sat',-1,
		'Sun',-2,
		'Mon',-3,
		'Tue',-4,
		'Wed',-5,
		'Thu',-6),
	"days")

Re: Filter to return previous Friday until current day.

Fred22 — Tue, 13 Feb 2018 17:27:10 GMT

This has worked. Thank you so much for your continued support!

So when next Friday roles around Feb 16th - it will only keep data from that Friday correct?

Re: Filter to return previous Friday until current day.

john_miller9 — Tue, 13 Feb 2018 17:37:37 GMT

That's correct - if you run the workflow on a Friday it will only keep data from that day.

Re: Filter to return previous Friday until current day.

Fred22 — Tue, 13 Feb 2018 17:54:14 GMT

Amazing. Thank you very much. I will mark the solution as correct. Have a great day.

Re: Filter to return previous Friday until current day.

Srikanth1729 — Wed, 01 May 2019 13:30:19 GMT

Hi,

Thanks for the solutions, but in this case, the answer changes on the month end, depending on the number of days in the month. Isn`t it?

Re: Filter to return previous Friday until current day.

roshnimehra — Wed, 08 May 2019 18:56:45 GMT

This helped me a lot.. Thanx..

Re: Filter to return previous Friday until current day.

Dsimps92 — Thu, 23 Mar 2023 11:37:02 GMT

You sir, rock.