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.
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