Expand my Community achievements bar.

Multiple aggregator functions in one column.

Avatar

Level 2

2/22/21

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=


2 Comments