cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Discover peer insights or crowdsource your one of a kind Designer question.

Create a new field with a rolling count

SOLVED
Highlighted
Meteoroid

I need to generate a new field for a rolling count, grouping by member and transaction date and break on year (reset counter) .  I have created a field for year that I can use, but I am not sure what tool to try and how to accomplish this.  Any help would be greatly appreciated!  Thanks!

 

MemberTransactionRolling Count
A22/29/20161
A25/3/20162
A26/23/20163
A211/6/20164
A25/21/20171
A25/22/20172

A2

 6/1/20173

A3

3/19/20161

A3

9/5/20162

A3

10/22/20163

A3

4/4/20171
Bolide
Perhaps you could use the Running Total tool? Maybe by setting up a field for year and a new column that contains 1 for each record. Then grouping by year and member and summing the new field.

Iain

Here is your solution.

 1. take out the year in an another field(say Year): Use Formula tool

       Right([Transaction],4)

 2. Use Tile tool, method will be "Unique" and Unique fields will be Method and Year.

 

Capture1.JPG

 

Thanks,

Vishwa

 

 

 

 

 

Meteoroid

Thank you!

Meteoroid

Thank you for the suggestion.