CC

Does anyone know how to group a set on rows totals that have a date column and sum them into a weekly total - either w/c or w/e?

by J Kirsch
Posted on Thu, 09/29/2011 - 10:14

Hi Charles,



MashZone does not containt calculation functionality for weeks. So in order to get the week for a date, you should use a webservice like this: http://www.onlineconversion.com/day_week_number.htm or - in case your data comes from excel - some functionality from there. Then, you would take the week as a separate column into your feed. You can then aggregate the row data using this 'week' column as reference. Either by using the 'aggregate' operator directly or implicitly by connecting the feed to a data display component in the 'Composer' of MashZone.

However: There is a way to calculate the week for dates with limited effort for a single year (e.g. 2011). The following 2 screenshots show how this can be done. I have to admit, that the value for 'WeekdayOf1Jan2011' might not be correct, but you get the idea.

regards

Jürgen

0
by Tes Sie
Posted on Tue, 11/15/2011 - 00:44

Hi Jurgen,

Wouldn't this be a much easier way to calculate the week.

 

0
by J Kirsch
Posted on Tue, 11/15/2011 - 14:01

Hello,



actually this took me by surprise! It seems to work (checked it), but i wasn't aware that the pattern 'w' is interpreted for date conversions.

MashZone does not offer 'w' as an available pattern. So you should be aware that this pattern is untested and we cannot guarantee that it works correctly in all circumstances.

We will check for version 2.3 of MashZone to include this pattern officially. Until then you have to use it at your own risk.

 

Kind regards

Jürgen Kirsch

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