Alteryx Designer Desktop Discussions

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

Help with Dynamic Rolling Total

dkberry
7 - Meteor

I need to create a rolling count field grouped by date and location the resets whenever rating = 0...as seen below. I'm not sure which Alteryx took to use. Any help would be greatly appreciated! Thanks

dkberry_1-1635779047608.png

 

 

2 REPLIES 2
HomesickSurfer
12 - Quasar

Hi @dkberry 

 

Configure a Multi-Row Formula tool as follows:

 

Capture.PNG

dkberry
7 - Meteor

Thanks!

Labels