Sorting in reports

samadam
Kilo Sage

‎03-14-2017 12:28 PM

I have a bar chart report for a table. I am trying to sort by a string field which has numbers as values. Sort does not work. I have values as

1, 2, 11, 14 , 22, 33. The sort just shows as   1,11, 14, 2, 22, 33 instead i wanted it sorted numerically. Is this possible?

0 Helpfuls
  • 1,822 Views
1 REPLY 1

Earl L
Mega Guru

‎03-14-2017 09:29 PM

Yeah, this is a tough one because that's exactly how numbers stored as strings are going to sort. Is this a custom table or field? The reason I ask is that if it is you might be able to extend the customization by adding a new column with integer data type and convert the strings to numbers and load them into the new column.



Failing that, you could probably use a custom chart and convert the strings to numbers in the source data script. Which way you go will depend on your preference and skills, and to some degree, the tolerance of your organization to live with one solution over the other. Hope that helps get things moving in the right direction.



Earl


0 Helpfuls