Sorting problem


https://www.nevron.com/Forum/Topic9216.aspx
Print Topic | Close Window

By Thomas Streitferdt - 5 Years Ago
Hello,

my x-Axis is sorting 0. 1. 10. 11. 12. 13. (...) 2. 3. 4. 5. ... . But I need 0. 1. 2. 3. (...) 10. 11. 12. 13. (...).
I think it´s because of the format in my database [Text], which I can´t change. Is there any solution how I can get the sorting that I need?
I hope you understand my problem!

Thank you for your help.
Thomas
By Nevron Support - 5 Years Ago

If we understand correctly you have some numbers in a data table column, that are plotted as titles on the category axis (Primary X) and you want to sort them as numbers. If this is the case you can follow these instructions:


1. Create a category grouping with the following grouping expression:
=Fields!YourTextField
2. Create a sorting rule for the category grouping with the following expression:
=TONUM(FIRST(Fields!YourTextField))

This should sort the category data groupings in ascending order and treat the strings as numbers.