Profile picture for user dhdillon

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

 

File attachments
by Stephan Freudl
Posted on Thu, 09/01/2011 - 08:25

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

0
by Nico Engel
Posted on Thu, 09/01/2011 - 09:49

Hello,

in the "Assign data"-dialog the sorting-mode of the X-axis is set to "Ascending" by standard, maybe you try to set it to "none"?!

With your test-data it works:

Ciao

Nico

0
by Donald Dillon Author
Posted on Thu, 09/01/2011 - 14:36

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

0
by Stephan Freudl
Posted on Thu, 09/01/2011 - 15:23

leading zeros, yes of course :)

0

Featured achievement

Question Solver
Share your expertise and have your answer accepted as best reply.
Recent Unlocks
  • BZ
  • Profile picture for user TEF_Bernd
  • ПЦ
  • CR
  • BH
  • PacMan

Leaderboard

|
icon-arrow-down icon-arrow-cerulean-left icon-arrow-cerulean-right icon-arrow-down icon-arrow-left icon-arrow-right icon-arrow icon-back icon-close icon-comments icon-correct-answer icon-tick icon-download icon-facebook icon-flag icon-google-plus icon-hamburger icon-in icon-info icon-instagram icon-login-true icon-login icon-mail-notification icon-mail icon-mortarboard icon-newsletter icon-notification icon-pinterest icon-plus icon-rss icon-search icon-share icon-shield icon-snapchat icon-star icon-tutorials icon-twitter icon-universities icon-videos icon-views icon-whatsapp icon-xing icon-youtube icon-jobs icon-heart icon-heart2 aris-express bpm-glossary help-intro help-design Process_Mining_Icon help-publishing help-administration help-dashboarding help-archive help-risk icon-knowledge icon-question icon-events icon-message icon-more icon-pencil forum-icon icon-lock