Filter Widget - User Input - Sort Options

Question

Happy Friday!

I don't know an easy way to ask this question -- we've got this difficulty field and we want users to be able to filter the data by it.  The challenge I'm having is that the options to filter aren't presented logically...

I've tried a couple ways of storing the data (straight text, using numbers as the stored value, and adding numbers to display name) ... adding numbers to the display name works, but it's not preferred ...

Anybody solved this one? Is it solvable?

jessneuner · Answer

for the curious -- another option and the one we'll go with

jessneuner · Answer

That's clever -- i will present to our customer to see what they think -- thank you!

Jeff.Thompson@arlingtontx.gov_arlingtontx · Answer

It's a bit of a pain, but if you make a New Filter for each item, you can arbitrarily sort them.