Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Multiple aggregator functions in one column.

Avatar

Level 2

22-02-2021

It would be nice if I could set up different “levels” of aggregator functions / expressions. I have run into this problem a couple of times but especially when trying to get correct percentages but my example will be simple. I am trying to create a report to look at Users and their hours.


User YTD Hours is a set number that will be the same in base row. (non grouping row)

  • In the 1st grouping, I need the aggregator to MAX so I can see the correct number of hours for the Owner.
  • In the 2nd grouping, I need the aggregator to SUM so I can see the correct number of hours that total for two of the Owners.
  • In the 3rd grouping, I need to the aggregator to SUM again so I can see the total number of hours on a company level.

My Idea: Set them up like the groupings. Make the last aggregator function the same for the next groupings if no more is needed or written in.


Example:

aggregator.0.function=MAX

aggregator.0.valuefield=

aggregator.0.valueformat=

aggregator.1.function=SUM

aggregator.1.valuefield=

aggregator.1.valueformat=

aggregator.2.function=SUM

aggregator.2.valuefield= (Since this would be the same as previous aggregator function, it would not need to be written)

aggregator.2.valueformat=


1 Comment