Alteryx Macro Unable to find connection

[SleimanSS]

I am making this simple macro to make a pareto analysis (80/20).

It's supposed to import a dataset and select the items analyzed, their sales, and overlays the profits. This part is fine.

Down in the metro I want the cutoff to be changed using another control parameter that connects to the filter tool. So the user can at the beginning of the macro change the cutoff to study 50% or 80% or 90% (not neccessarily the 80% from the 80-20 rule).

The second control parameter is defaulted to 80%, but when the macro is saved and run in a regular workflow it says "cannot find connection", and any change to the number still results with the analysis done at 80%, i.e the default value. What am I missing here?

[atcodedog05]

Hi @SleimanSS 

You need to make the below changes.

Your select box requires to select a source of input.

Main workflow

Personally i dont think you need the seletbox. Since its already taking mapping as part of input.

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[SleimanSS]

Thank you. The missing connection issue has been resolved, but not the cutoff issue. I thought the missing connection was what was stopping the cutoff from working.  Any idea why that would be?

I included updated versions of the workflow / macro. 

[atcodedog05]

Hi @SleimanSS 

No the missing connection was not creating the issue for cutoff.

I checked it seems to be working.

Cutoff: 80

Cutoff:95

Output for cutoff 80 and 90 where same and changed only when i changed to 95. Guess the difference occurs only between few ranges.

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[atcodedog05]

Hi @SleimanSS 

Hope it clarify things 🙂

If my post helped you please mark it as solution. 😀

[SleimanSS]

This is very weird. The cutoff is not working on my machine. I have the action tool doing the following. 

Am I missing something? It's super weird that it works on yours and not on my computer!

[atcodedog05 · Accepted solution]

Hi @SleimanSS 

Can you apply the below config and try.

And you can see the output difference only in R and S macro output anchor.

[SleimanSS]

That worked. Thank you!

[atcodedog05]

Happy to help 🙂 @SleimanSS 

Cheers and Happy Analyzing 😀