Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

How to checking on the Progression using Alteryx tools

shijieleong
7 - Meteor

Hi , 

 

Question: 

 

I want to track the progression of the sales target.

Current month is 10 month, and all the target are cumulative. I would like to find out with the current total sales number achieved at which month of the sales person meeting the target. 

 

Please refer to the attached data. 

3 REPLIES 3
MichelleL
Alteryx
Alteryx

@shijieleong Using a Join tool should get you the results you need.  Please see attached workflow and let me know if this works for you!

MichelleL_0-1654617804918.png

 

shijieleong
7 - Meteor

Hi Michelle, 

 

Thank you for your reply, my expected result is if the FC did not met current month target then what is the progression point, eg: 20002, 

FC did not meet month 10 target but the sales person has cleared month 5 target. 

 

Thanks 

MichelleL
Alteryx
Alteryx

@shijieleong I've added logic to choose which month the Sales meets the Target.  Let me know if this works for you :-)

 

MichelleL_0-1655307484286.png

MichelleL_2-1655307533235.png

 

Labels