I got this fantastic Dynamic Summarize macro from BenMoss here: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Remove-a-field-from-summarize-...
I have also attached the workflow and macro in this post.
Problem Statement #1:
I am having a hard time creating an interface whereby users can select their dimensions & measures of choice based off the dataset. Mind you, the original source actually comes from a Database, but I have used a dummy value in order to simulate what I need. How do I configure the interface tools further so that end-users can just choose their dimensions & measures of choice?
Potential Idea #1:
With the control container, is it possible to add it to the workflow so that a chain app can be avoided? Basically, the DB will output a YXDB and will connect to the workflow simultaneously, but the YXDB will serve as the drop-down/list-box options of the interface.
Problem Statement #2:
After an interface is created, I need to connect it to a formula tool in order to calculate the [First Measure]/[Second Measure] always. The problem is, if a user is given free reign to choose any dimensions and measures, I can solve the Group By problem and Sum issue, but not the Formula issue because the name of the measure changes depending on order of item selected or even the field selected for aggregation.
How do I therefore, make the formula dynamic, to cater to the first and second measures always?
All help & advice is massively appreciated!
Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
