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

Increment Count for Two Columns Conditions

theinsideguy
7 - Meteor

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.   

 

ApplicationDateCustomer ActionOutput
11/1/2015Entered Mobile Site1
11/15/2015Clicked Page X2
15/5/2016Bought Something3
110/5/2017Used Paypal4
23/6/2019Entered Desktop Site1
22/1/2020Clicked Page X2
21/2/2021Bought Something3
21/5/2021Used Credit Card4
24/5/2021Credit Card Declined5
35/15/2021Entered Mobile Site1

 

 

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! 

4 REPLIES 4
apathetichell
18 - Pollux

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

theinsideguy
7 - Meteor

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. 

 

ApplicationDateCustomer ActionOutput
11/1/2015A1
11/15/2015B1
15/5/2016A2
110/5/2017B2
23/6/2019A1
22/1/2020B1
21/2/2021B2
21/5/2021A2
24/5/2021B3
35/15/2021A1
apathetichell
18 - Pollux

2021-06-27 (6).png

2021-06-27 (7).png

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

theinsideguy
7 - Meteor

Thank you so much! I understand this tool much better now. Cheers! 

Labels