Alteryx Designer Cloud Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Cloud.

How can I filter for the highest value? Can you help me Plz.

TrifactaUsers
10 - Fireball

Example: I have 3 value 

425

48888

1522265

And i wanna chose only 1522265

1 REPLY 1
APrasad_Tri
Alteryx Alumni (Retired)

Hi @Youssef LAHIOUEL? , thank you for reaching out!

 

You can use the Filter transform from the toolbar. Select the custom filter as shown below

Enter the below code in the custom section. Please make sure Custom multiple is selected "Type of Formula" section.

column1 == MAX(column1)

 

 

 

Or you can find the MAX value, using the aggregation function from the tool bar

 

select Group by as a new column

Filter rows from toolbar as shown below

 

 

Hope this helps. Please let us know if you have any issues.

 

Best,

Apeksha Prasad