return max rows

[Nastya]

Hi everyone! I have the following problem - I need to find Preferred type based on the number of visits. E.g. if the visitor visited opera and ballet the same number of times than he prefers both - opera and ballet

Visitor	Type	# of visits
User1	Opera	1
User1	Ballet	1
User2	Opera	2
User2	Ballet	1
User2	Concert	2
User3	Ballet	3

Output:

Visitor	Preferred type
User1	Opera
User1	Ballet
User2	Opera
User2	Concert
User3	Ballet

[Thableaus · Accepted solution]

Hey @Nastya

Here's the solution that I thought.

Cheers,

[ponraj]

Here is the sample workflow for your case. Hope this is helpful. 

WorkflowResults