Is there a setting somewhere which changes the sort definition in the data assignment settings? My issue is that I have categories that I want to sort by, the field name is 'Aging category' and the content of this field is, for example:
90
120
183
270
365
5000
Despite having numbers as content the field is defined as text so that I can group on them (count number of applicable records)
My output sorts as follows:
120,183, 270, 365, 5000, 90
Image is attached.
Any suggestions will be appreciated
thanks
donald
Hi Don,
yes, that's tricky. On the one hand MashZone requires you to plot your numbers as text - to have your categories on the x-axis. On the other hand MashZone sorts lexicographically, so 10 precedes values 2-9. As of today there is no way but insert trailing zeros manually. Once you have 01,02,...,10 it should be fine.
Regards
Stephan
Thanks for the feedback.
I solved the problem by adding 'leading zeroes', trailing zeroes would have changed my 90 into 900.
Eliminating the sort did not work. Possibly because my data was not sorted in the datafeed. I am taking several thousand records and filtering and assigning them to a category in the datafeed and this results in the datafeed not being sequenced before being presented. It was worth a shot.
thanks
donald