Computing Mode for table values

Last activity on October 1, 2023 - 11:21 24.3k Views 1 Reply MashZone

Maciej Owczarek on October 24, 2011

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.

1 Reply

Stephan Freudl on October 31, 2011

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

Like

Sign in
or register to reply.

Notify Moderator