Increment Count for Two Columns Conditions

theinsideguy

Hello, I have three columns "Application", "Date" and "Action" in my existing table. What I am trying to do is generate a fourth column from this existing data that incrementally counts the output by Application and Date. For each application, the count begins at 1 again.   

Application	Date	Customer Action	Output
1	1/1/2015	Entered Mobile Site	1
1	1/15/2015	Clicked Page X	2
1	5/5/2016	Bought Something	3
1	10/5/2017	Used Paypal	4
2	3/6/2019	Entered Desktop Site	1
2	2/1/2020	Clicked Page X	2
2	1/2/2021	Bought Something	3
2	1/5/2021	Used Credit Card	4
2	4/5/2021	Credit Card Declined	5
3	5/15/2021	Entered Mobile Site	1

The closest I've gotten is to create a dummy column that has all 1's. I then have the running total tool that I group by Application. However, I can't get the date part right (when I groupby date as well, everything is 1). 

A little new to Alteryx, so I appreciate any help! 

apathetichell

Tile tool - set it up for unique values in your id field and it will give you a count... I've included how to convert your dates to alteryx format dates so you can sort by them and use them in datetime formulas...

tile sequence is your friend.yxmd