Interface Element Populating a Formula

[vgamon]

Hello! I am working on a workflow where I have multiple periods that can be selected (1-6 for now). These periods are all independent columns in the data set. Then, I use a formula to find the variance of two or more of the periods for analysis. I am wondering if there is a way to: 

1) Prepopulate the interface element (list) from the columns itself without needing to hard code the periods. I want there to be a way for the user to select however many periods to calculate. 

2) Use the formula and calculate only those items that the user has selected? 

[ArtApa]

Hi @vgamon - Yes, it is possible. You need an App. I suggest you to review the following resources:

• Weekly Challenges that are focused on apps. For example: https://community.alteryx.com/t5/Weekly-Challenge/Challenge-215-Gotta-Catch-em-All/td-p/568146 
• Interactive Lessons: https://community.alteryx.com/t5/Interactive-Lessons/tkb-p/interactive-lessons/label-name/Creating%2... 

Good luck!