Sort table based on decimal value not working


I am not sure how retool's sorting in table working. For integer type of data it seems to work correctly, but when my data is decimal ( 0.34 , 0.44 ...) it fails to sort the table rows when updating

Let me know what's wrong here.

Without being able to see the data for that custom column I imagine that it's actually a string not a number so the sorting isn't as you expect. Can you check the data type is numeric and not a string?

thanks for reply,

column type was auto. I see that setting it number made it work as expected but shouldn't that be handled with auto type though (!)

Definitely agreed that Auto should be able to handle sorting decimals. Linked this thread to an internal ticket to address though, a genuine thank you for sharing your experience here!

1 Like