Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Alteryx summarise iterative macro

SimonSturges
7 - Meteor

Hi, I'm working on a very large dataset with lots of dimensions where I need to pre-calculate the distinct number of orders based on different hierarchies. I've built a simple workflow with dummy data based on Tableaus superstore dataset which demonstrates what I'm trying to achieve but I need it to be dynamic so the user can select multiple fields and the alteryx macro will calculate all possible levels. My thought is that an iterative macro would be the solution here but I'm unable to figure out the logic or find similar examples online. Any help would be appreciated. 

1 REPLY 1
Qiu
20 - Arcturus
20 - Arcturus

@SimonSturges 

This is not exactly you are asking, but I think it will give a hint to start with.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Remove-a-field-from-summarize-in-a-mac...

Labels