We are using OOTB optimization and personalization features, with a text property, but the values are decimal. We have the table set to integer for that property. The sorting seems to sort like a text value. We are looking for a way to correctly sort these numbers. (even if its sorting as a decimal).
Does anyone have good suggestions for using the OOTB sorting features on the table?
Please see the image, the very last value makes it super obvious that its not sorting correctly.
The numbers start low, then get higher but the last value is a lot lower.
@KevinH87 are the values displayed inside table in a text input? If its a text input the values will be considered as String and the sorting will be based on dictionary order. Try using Number input type inside the grid cell and check the behavior.