Drop down list not showing in asc or desc order

Looker Q&A Looker
1

Hi, I have an issue with one chart in a report. The Drop down list filter doesn´t show the values in order based on the number in the beginning of the field´s value. I´ve tried recreating the filter with no luck. In the other pages of the report with similar specifications it shows all the values ordered by the number in the beginning of the value. The screenshot shows the problem.

  • Näyte = sample
  • As you can see the numbers go in descending order from 9->3 but the last ones are 11 and 10.
  • The number range in the dropdown samples is 3-11 based on a filter.

Näyttökuva 2024-10-14 kello 13.24.40.png
Näyttökuva 2024-10-14 kello 13.24.40.png1022×380 48.3 KB

Thanks for help!

2

That’s expected since the numbers at the beginning are treated as texts and not as number. You can lpad the single digit numbers with a leading “0” so that the filter values appear in the expected order.