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.
SOLVED

Create a new field with a rolling count

jillvecc
7 - Meteor

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
4 REPLIES 4
ivoller
12 - Quasar
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
vishwa_0308
11 - Bolide

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

 

 

 

 

 

jillvecc
7 - Meteor

Thank you!

jillvecc
7 - Meteor

Thank you for the suggestion. 

Labels