community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE

Find out whether the status of the customer has changed based on ID

Hi All, 

 

I am looking to figure out a solution to answer how many customer's status changed from Guest to Registered and how many from Registered to Guest. 

 

Attached is the example of my data.

 

I have tried multi-row formula and some macros but I am stuck to get the right answer. 

 

Any help would be appreciated

 

Thanks

Alteryx Certified Partner

Hi,

 

it should be possible to solve the problem by Multi-Row formula, I've attached a sample workflow.
There may be addition logic required to handle a "switch back" (status changes from GUEST to
REGISTERED and back to GUEST - how would you like to count this?). Hopefully the sample is
helpful.

 

Best regards

 

Roland

Labels