Highest Value from a Group of Attributes

[sghani87]

Hi All

I am trying to identify the best performing Dealership ID from a Group of Attributes. In Excel I would have used a Max If array formula, not sure how to best achieve this in Alteryx? grateful for any help

kind regards

Sid

[grossal]

Edit: When I saw @AbhilashR's post, I noticed I got the problem wrong. Go with his solution. (I won't adapt mine cause he was faster with the right solution and the credit belongs to him)

-----Original Post-----

hi @sghani87,

here is a way to do achieve this with Alteryx:

What happens:

1) Remove Dollar Sign

2) Remove Punctuation from the Revenue

3) Right data type

4) Get max per Dealership-ID

5) Join both back together

6) View the data

Output:

I'll attach the workflow. Let me know if it helps!

Regards

Alex

[AbhilashR · Accepted solution]

@sghani87 - Attached is an attempt to replicate the output you had in your .PNG file.

Let us know if this answers your question.

[AbhilashR]

@grossal - you are too kind, Alex! 🙂

[sghani87]

Thank you for coming back to me, much appreciated.