How to show all values except for one in a dropdown?

[yvassilyeva]

Hi!

I have a dropdown with one of the values being "Unknown", and I would like to have an option in the dropdown to show each value,  All, and also include an option to show "All except for Unknown".  Has anyone been able to do so?

Thank you very much!

[skrajkumar_splu]

Next to All add " Except Unknown" also as a static option with value as 

* AND data!="Unknown"

here data is the field name you are going to search in the query like data = $dropdown$. This should help in filtering all values of data except "Unknown"

If this answer helps. kindly accept it as a Solution and upvote it.