HR

Hi,

I'm trying to figure out how to correctly get data sorted in a column chart in a MashApp.

The data that is to be displayed is a set of columns from a data feed with some aggregated data for events per month. The information of which month the data is collected in, is present in both the form of short name (JAN, FEB etc.) and the number of the month (1,2 etc.). I can only use the short name column as input for my X-axis (as it only allows for text input), but that will only allow me to sort the months in alphabetical order. Can I use the month number in some way to get this working correctly(tried it as an additional column which now lets me sort on that value, but that will also add the value of the month to the aggregated event data)?

Hope I made this clear.

Regards,

Håkan

by Francis Chan
Posted on Tue, 01/10/2012 - 06:45

If you change your x-axis data type to date format e.g. yyyy-mm, they should then be sorted correctly.

0

Featured achievement

Rookie
Say hello to the ARIS Community! Personalize your community experience by following forums or tags, liking a post or uploading a profile picture.
Recent Unlocks

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