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!
Solved! Go to Solution.
Thank you so much. As an addon to the question, can the tile tool count how many of the same Customer Actions there are for each application? The unique feature doesn't seem to work in that way.
Application | Date | Customer Action | Output |
1 | 1/1/2015 | A | 1 |
1 | 1/15/2015 | B | 1 |
1 | 5/5/2016 | A | 2 |
1 | 10/5/2017 | B | 2 |
2 | 3/6/2019 | A | 1 |
2 | 2/1/2020 | B | 1 |
2 | 1/2/2021 | B | 2 |
2 | 1/5/2021 | A | 2 |
2 | 4/5/2021 | B | 3 |
3 | 5/15/2021 | A | 1 |
Glad to hear it worked! love the Tile tool - try it again this time set for unique value with the same determinant but add grouping by customer action - and take the tile sequence number...
Thank you so much! I understand this tool much better now. Cheers!