Join the Alteryx Community’s Maveryx Summer Cup event! Compete, network with others, and earn your gold through a series of challenges from July 24th to August 11th. Learn more about the event here.
community Alteryx IO Alteryx.com
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

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
‎11-01-2021 08:07 AM

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

 

 

Labels:
Reply

Accepted SolutionSolved! Go to Solution.

2 REPLIES 2
HomesickSurfer
12 - Quasar
‎11-01-2021 08:27 AM

Hi @dkberry 

 

Configure a Multi-Row Formula tool as follows:

 

Capture.PNG

Reply
dkberry
7 - Meteor
‎11-01-2021 08:34 AM

Thanks!

Reply
apply to be an alteryx mentor
Join the tampa, florida User Group
Labels