COUNTIFS - Shown in summary form based on multiple criteria

[Inactive User]

I have a dataset that shows transactions of users buying products during a session with price and quantity. 

What I what to try and do is see if it possible to run a COUNTIFS type formula that will spit out a summarized sheet to show if users may have completed 2 transactions in one Session ID. 

I need to make sure it only counts when Session ID and User ID are the same. 

Is it possible to do this in Alteryx? 

Any help would be greatly appreciated!

[BenMoss · Accepted solution]

Very simple.

Use the summerize tool, grouping by your user ID and session ID field, and then perform a countdistinct of your transactionID field.

Ben