Profile Picture

Sorting problem

Posted By Thomas Streitferdt 9 Years Ago
Author
Message
Thomas Streitferdt
Problem Posted 9 Years Ago
View Quick Profile
Forum Newbie

Forum Newbie (0 reputation)Forum Newbie (0 reputation)Forum Newbie (0 reputation)Forum Newbie (0 reputation)Forum Newbie (0 reputation)Forum Newbie (0 reputation)Forum Newbie (0 reputation)Forum Newbie (0 reputation)Forum Newbie (0 reputation)

Group: Forum Members
Last Active: 9 Years Ago
Posts: 3, Visits: 38
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

Nevron Support
Posted 9 Years Ago
View Quick Profile
Supreme Being

Supreme Being (4,434 reputation)Supreme Being (4,434 reputation)Supreme Being (4,434 reputation)Supreme Being (4,434 reputation)Supreme Being (4,434 reputation)Supreme Being (4,434 reputation)Supreme Being (4,434 reputation)Supreme Being (4,434 reputation)Supreme Being (4,434 reputation)

Group: Forum Members
Last Active: 2 days ago @ 7:05 AM
Posts: 3,053, Visits: 3,958

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.



Best Regards,
Nevron Support Team





Similar Topics


Reading This Topic