User Input as Variable, which is like filter in a column and use these variable in formula

I need help on my workflow, where table has following columns:

Type	Date
A	3/31/2018
B	3/31/2018
C	4/30/2019
A	2/28/2019
B	12/31/2018
C	12/31/2019

User needs to choose or input two dates for example 12-31-2018 and 12-31-2019 and view the comparison between "Type" on these two dates.

Please let me know if you can help with this.

Thanks,

Developer Tools

Accepted answers

BrandonB

Assuming that you already have a workflow built out, you can add interface tools as shown below which allow for an end user to pick the dates which will filter the data that is passed through. If you have not yet built an analytic app before it would be helpful to view a training video. Does your company currently have Alteryx Server? In order to deploy this app to other users in a web interface you will need Alteryx Server to do so.

interface filter.png

DavidP

As shown in @BrandonB's example, from your date selectors, drag from the Q to the lightening bolt on the filter tool (instead of the Q) - this will automatically insert an Action tool where you can select Update Value.

yaminibhola

I was able to resolve this.Thanks all for helping.

All comments

BrandonB

interface filter.png

BrandonB

Here is a training video on turning an Alteryx workflow into an Analytic App: https://community.alteryx.com/t5/Videos/Introduction-to-Applications/td-p/45406

yaminibhola

Thanks for the help here.However I am not getting update value in between,do you know why?

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703