How to add a functionality to select a value and then others with reference to it

[abhinavrpk]

Hi,
Thanks to the Alteryx community who helped me in making my first workflow ( as in the image)
I was able to get the desired results. 

Now I would like to add a functionality where in I select a period manually and then with reference to that selection, the next steps flow.

Below is the output at crosstab (Pivot table) .

Jurisdiction	Aggr Period	Scenario 1	Scenario 2	Scenario 3	Scenario 4
CANADA	20200920-20201020	20	2
CANADA	20201020-20201116	40	0
CANADA	20201116-20201214	55	0
CANADA	20201214-20210111	24	0
CANADA	20210111-20210207	2	0
CANADA	20210207-20210307	21	0
CANADA	20210307-20210404	52	0
CANADA	20210404-20210503	12	0
CANADA	20210503-20210530	12	0
CANADA	20210530-20210627	2	0
CANADA	20210627-20210725	0	0
CANADA	20210725-20210822	0	0
CANADA	20210822-20210919	2	0
CANADA	20210919-20211017	8	0
CANADA	20211017-20211114	0	0
CANADA	20211114-20211213	65	0
CANADA	20211213-20220110	2	0
CANADA	20220110-20220206	42	8
CANADA	20220206-20220306	5	5
USA	20200925-20201023			83	2859
USA	20201023-20201120			72	2728
USA	20201120-20201218			72	1400
USA	20201218-20210116			77	1427
USA	20210116-20210205			55	1082
USA	20210205-20210312			101	1887
USA	20210312-20210409			85	1701
USA	20210409-20210507			81	1642
USA	20210507-20210604			83	1690
USA	20210604-20210702			72	3449
USA	20210702-20210730			72	3483
USA	20210730-20210827			77	3604
USA	20210827-20210924			55	1400
USA	20210924-20211022			101	1427
USA	20211022-20211119			85	1082
USA	20211119-20211217			81	1887
USA	20211217-20220114			5222	1701
USA	20220114-20220212			4391	1642
USA	20220212-20220311			4397	1690

This selection needs to be made at cross tab. Now if I select the aggr period as 20211017-20211114, then the system should treat it as latest aggr and follow the next steps considering this as latest aggr period and then selecting 14 aggr period with reference to this one.
As we have diff aggr periods for Canada and US, we need to make sure that we select a particular value for both the type of jurisdiction.

Please guide as to what is the best possible way to include this functionality.

Thanks
Abhinav 

[JarekSkudrzyk]

@abhinavrpk hi, please take a look at my proposed solution. In the filters placed on yellow background the user has to choose the proper aggr period.

[JarekSkudrzyk]

@abhinavrpk you can union both streams at the end to obtain a single output

[binuacs]

@abhinavrpk another way of doing this by giving the dates in separate input file

[abhinavrpk]

Thank you for your responses. I am basically looking for functionality where I select the current Aggr period and with reference to that, all the next calculations work. Is there something that I can do using the macro/ control parameter/drop-down tool or the list box? 

[soccertil1108]

Interactive workflows can be created with the Interface tools thus creating an Alteryx Application. Depending upon the level of sophistication that you require you also might need to understand how to create chained applications. If you can provide some additional details about the user interface you require I can show you a sample workflow. Alteryx has some training on applications and I have a number of video that I can link you to as well.

[abhinavrpk]

Hi Soccertil 1108
Thank you for the response. Yes I am looking for such a solution. I will explain the whole workflow again. 
As shared in my initial workflow image, I have selected a path for both the input files. There are a number of files. Each file has the latest aggregation period and also the values of the last 19 aggregations for each scenario. 
The aggregation period corresponds to a range of dates. Now when I club all the files to have a historical data, I bring the values for all scenarios corresponding to each aggregation period as an average value. 
The interactive functionality I am looking for is this, consider the workflow image attached to initial post, when we select all the files, this workflow gives me the calculations I am looking for with the latest aggregation period. Here I am looking for an interactive menu that lists all the aggregation period and enables me to select one of them and does the onward calculations keeping that selected aggregation period as my latest aggregation period. 
Looking forward to your response. 
Thanks,
Abhinav

[abhinavrpk]

Thank you for this solution Jarek. This definitely works to a great extent. I am looking to make it interactive and it would be great if you can suggest me something on that lines too. 

[soccertil1108]

Since applications start with prompting the user for input, you will need to first run an app that creates the data and writes it to an file. The first app will need to chain to a second app that reads the created file and prompts the user for input. The second app will the take action on the input and finish the workflow. Alteryx has a learning module for apps. I have a video that walks through the app chaining scenerio that can help you build the chaining application.

https://youtu.be/oSYe0-jsbyA

[JarekSkudrzyk]

@abhinavrpk as @soccertil1108 said - Alteryx has great learning materials on apps and chaining apps - you can check them out here:
https://community.alteryx.com/t5/Interactive-Lessons/tkb-p/interactive-lessons/label-name/Creating%2...