CM

Hi ARIS Community,

I really need your help in resolving the following 2 challenges using the attached Excel sheet (see below):

1) How am I able to define a data feed in a way, that the 2nd to 13th columns are defined as months?

2) Is there a fast solution to change the data type from simple numbers to percentages? Do I have to multiply every single cell by 100?

 

Thanks and best regards,

Christoph

File attachments
by Stephan Freudl
Posted on Tue, 01/26/2010 - 09:23

Hi Christoph,

your first question has already been asked and answered ;)

The second one: Yes as MashZone - for the sake of simplicity - does only know about number (decimal), text and date. Please note: The pie chart for instance converts such values into percentages automatically.

Regards

Stephan

0
by Christoph Matzka Author
Posted on Tue, 01/26/2010 - 13:23

Hi Stephan,

thanks for your answer!

A transpose operation would be very helpful and very appreciated!

 

Best regards,

Christoph

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
  • SS
  • MZ
  • Profile picture for user kbiront
  • Profile picture for user Tony Iliev
  • Profile picture for user amandeep.7.singh
  • 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