Inspire EMEA 2022 On-Demand is live! Watch now, and be sure to save the date for Inspire 2023 in Las Vegas next May.
We'll be completing standard maintenance for our Single Sign-On system on November 30th 6pm Pacific Time for approximately one hour. During this time My Alteryx and sign-in functionality to all My Alteryx programs (Licensing Portal, Community, Beta Program, Case Portal, and others) may be inaccessible. Thank you for your patience.

Alteryx Designer Discussions

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

Using filter tool using multiple conditions

dunkindonut7777
8 - Asteroid

Hi I have a problem here that I want to filter it using the criteria below:

 

1. How many students failed?
2. How many students have 80 and above grade and less than 90?
3. How students have Student Numbers that ends with 0?
4. How many students with names started with letter B?
5. How many students Students Number thats ends with 0 and Passed?

 

Student NoStudent NameGradesRemarks
100Humba Dela Cruz90Pass
101Afritada Reyes74Fail
102Bicol Express Jr.87Pass
200Omelette delos Reyes95Pass
209Biplop Sandoval85Pass
208Laing Bernal82Pass
305Sinigang Santos90Pass
306Cornbip Lacson98Pass
380Fried Egg Aguinaldo74Fail
400Tocino Fernando III65Fail

 Can you help me with this one pls?

2 REPLIES 2
matt_dix
9 - Comet

Hi @dunkindonut7777 

 

Using the Custom filter in the Filter Tool this is the syntax I would use, you can take out the bits you need into separate Filter Tools (or even the Formula Tool if you looking to add another column to classify. Just be aware that a student can fall into more than one of these categories.) as required as you don't specify an output

 

[Remarks] = "Fail" //How many students failed?

OR ([Grades] >= 80 AND [Grades] < 90) //How many students have 80 and above grade and less than 90?

OR EndsWith(ToString([Grades]), "0") //How students have Student Numbers that ends with 0?

OR StartsWith([Student Name], "b") //How many students with names started with letter B?

OR (EndsWith(ToString([Student No]), "0") AND [Remarks] = "Pass") //How many students Students Number thats ends with 0 and Passed?

 

Matt

AlexEntz
8 - Asteroid

Hello,

 

here are the requested Filters in Order.

 

AlexEntz_0-1652946926265.png

 

 

Workflow is attached as well.

Labels