MO

Hi all,

is there a option for agregation block to pass all values.

I'm trying to compute a mode for values in table.

Columns are [Month] [Aging]

 

First agregation works great but after the second I do not have the Aging value.

The goal is to have output Month and value that occur most often (value aging must be greater then 0).

 

Thanks in advance.

by Stephan Freudl
Posted on Mon, 10/31/2011 - 15:40

Hi,

I am not sure about your goal. Do you want the maximum and count of your count column grouped by column month?

In this case I'd suggest you duplicate the column count before aggregating. This enabled you to use only one aggregation operator but aggregating max and cnt at the same time.

 

Regards

Stephan

0

Featured achievement

Question Solver
Share your expertise and have your answer accepted as best reply.
Recent Unlocks
  • CP
  • BZ
  • Profile picture for user TEF_Bernd
  • ПЦ
  • CR
  • 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