Hi all I am looking for a way to simplify a workflow based on people leaving my firm and add a dropdown box or 2 to select a day, then use a date range to select the required data (if that make sense). I presently have, in my workflow, multiple filters, as below : * datetimeformat(DateTimeNow(),"%a") = "Mon" * datetimeformat(DateTimeNow(),"%a") = "Tue" * datetimeformat(DateTimeNow(),"%a") = "Wed" * datetimeformat(DateTimeNow(),"%a") = "Thu * datetimeformat(DateTimeNow(),"%a") = "Fri" Each of the 'day' filters then runs another 2 filters to output data based on the current week, and the following week (need to be seperated). For the Monday filter I then run 2 seperate filters * ([Departure Date] >= DateTimeFormat(DateTimeAdd(DateTimeToday(), +1,"days"), '%Y-%m-%d') AND [Departure Date] = DateTimeFormat(DateTimeAdd(DateTimeToday(), +8,"days"), '%Y-%m-%d') AND [Departure Date] = DateTimeFormat(DateTimeAdd(DateTimeToday(), +0,"days"), '%Y-%m-%d') AND [Departure Date] = DateTimeFormat(DateTimeAdd(DateTimeToday(), +7,"days"), '%Y-%m-%d') AND [Departure Date] <= DateTimeFormat(DateTimeAdd(DateTimeToday(), +13,"days"), '%Y-%m-%d')) the same applies for the rest of the week (excluding Weekends) I'm looking to implement the dropdown box so my team members can select Monday, then the workflow uses the appropriate filters 2 filters, or if the day is Tuesday then run the appropriate filters. Is this possible ? Any suggestions or recommendations would be greatly appreciated. My apologies if my questions are vague.

Hi again @pedrodrfaria When I run the Analytics App tool, I get the following popup box

Hi again @pedrodrfaria and @Vijuzy I've had another look at your WF and have worked out I wasn't running them as an "Analytic App", which I've now fixed, but can't see how to make the dropdown box select the filters based on the "day' selection per the examples below * If Monday run these 2 filters :* Filter 1* ([Departure Date] >= DateTimeFormat(DateTimeAdd(DateTimeToday(), +1,"days"), '%Y-%m-%d') AND [Departure Date] = DateTimeFormat(DateTimeAdd(DateTimeToday(), -4,"days"), '%Y-%m-%d') AND [Date Completed] = DateTimeFormat(DateTimeAdd(DateTimeToday(), +8,"days"), '%Y-%m-%d') AND [Departure Date] =DateTimeFormat(DateTimeAdd(DateTimeToday(), +0,"days"), '%Y-%m-%d') AND [Departure Date] = DateTimeFormat(DateTimeAdd(DateTimeToday(), +7,"days"), '%Y-%m-%d') AND [Departure Date] <= DateTimeFormat(DateTimeAdd(DateTimeToday(), +13,"days"), '%Y-%m-%d')) * Then output data as final step I currently have 5 separate filters for each weekday (similar to the above), and hoping to consolidate/tidy the process making it less confusing for my colleagues, eliminating 4 of the day selections, using the dropdox box selection/s I hope that explains my wokflow a bit better

Hi @StephenT You need to run as an App, then you will see the dropdown menu: You can use either the Drop Down, the Text Box or the Date tool, all from the interface tools in order to make the App work. Pedro. Dropdown box to select a specific day then run 2 filters.yxwz

Dropdown box to select a specific day then run 2 filters

StephenT

Hi all

I am looking for a way to simplify a workflow based on people leaving my firm and add a dropdown box or 2 to select a day, then use a date range to select the required data (if that make sense).

I presently have, in my workflow, multiple filters, as below :

datetimeformat(DateTimeNow(),"%a") = "Mon"
datetimeformat(DateTimeNow(),"%a") = "Tue"
datetimeformat(DateTimeNow(),"%a") = "Wed"
datetimeformat(DateTimeNow(),"%a") = "Thu
datetimeformat(DateTimeNow(),"%a") = "Fri"

Each of the 'day' filters then runs another 2 filters to output data based on the current week, and the following week (need to be seperated).

For the Monday filter I then run 2 seperate filters

([Departure Date] >=
DateTimeFormat(DateTimeAdd(DateTimeToday(), +1,"days"), '%Y-%m-%d') AND [Departure Date] <=
DateTimeFormat(DateTimeAdd(DateTimeToday(), +7,"days"), '%Y-%m-%d'))
([Departure Date] >=
DateTimeFormat(DateTimeAdd(DateTimeToday(), +8,"days"), '%Y-%m-%d') AND [Departure Date] <=
DateTimeFormat(DateTimeAdd(DateTimeToday(), +14,"days"), '%Y-%m-%d'))

For the Tuesday filter I then run 2 seperate filters

([Departure Date] >=
DateTimeFormat(DateTimeAdd(DateTimeToday(), +0,"days"), '%Y-%m-%d') AND [Departure Date] <=
DateTimeFormat(DateTimeAdd(DateTimeToday(), +6,"days"), '%Y-%m-%d'))
([Departure Date] >=
DateTimeFormat(DateTimeAdd(DateTimeToday(), +7,"days"), '%Y-%m-%d') AND [Departure Date] <=
DateTimeFormat(DateTimeAdd(DateTimeToday(), +13,"days"), '%Y-%m-%d'))

the same applies for the rest of the week (excluding Weekends)

I'm looking to implement the dropdown box so my team members can select Monday, then the workflow uses the appropriate filters 2 filters, or if the day is Tuesday then run the appropriate filters.

Is this possible ? Any suggestions or recommendations would be greatly appreciated.

My apologies if my questions are vague.

Workflow

Tips and Tricks

Date Time

Accepted answers

All comments

StephenT

I've attached a screenshot of the date filters

pedrodrfaria

Hi @StephenT

An easy solution would be to have the user select in the dropdown menu "Monday" for example, then this dropdown updates a Text Input, then with a append fields, you populate the dataset with Monday and the filter you have uses Monday as the factor to move forward with the workflow.

I attached an workflow to cover the concept.

Pedro.

Dropdown box to select a specific day then run 2 filters.yxwz

StephenT

Thanks @pedrodrfaria

Unfortunately i can't open your sample.

I am using Ver 2019.3.5.17947 if that helps

Vijuzy

Hi @StephenT ,

You can use interface tools to get user input and update it within workflow and use it in formulas. I have provided an example workflow and made it compatible with 2019 version of Alteryx. Hope it helps.

Regards,

Vijay

Dropdown box to select a specific day then run 2 filters.yxwz

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703