The sorting feature is not working properly on percentages. It is ranking 5% higher than 10% or 15%. I believe it is because it is looking at the leading integer rather than the number as a whole.
You are using a string-type column, so it can't be sorted as a number. You need to change the column type to be Integer, and then add the suffix (%) so it can be sorted normally.
Hello,
The sorting feature is not working properly on percentages. It is ranking 5% higher than 10% or 15%. I believe it is because it is looking at the leading integer rather than the number as a whole.
Any fix for this?
Thanks!
-Lee
Hello Lee
Thank you for your purchase.
You are using a string-type column, so it can't be sorted as a number. You need to change the column type to be Integer, and then add the suffix (%) so it can be sorted normally.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables