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

[yaminibhola]

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,

[BrandonB · Accepted solution]

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. 

 

[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?

[DavidP · Accepted solution]

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]

Thanks I did, still getting

[yaminibhola · Accepted solution]

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

[hemant86]

Really appreciate if you could share the solution please

[BrandonB]

Hi @hemant86 

The action tools are ultimately used to update part of or an entire expression. Whatever tool they are connected to, you will want to make sure that the values passed in are updating the corresponding components of the expression.