Hello All,
I am pulling a hour report for specific Type of Project (custom field we built) for a specific user. I grouped the report by project, but one of the managers would like to know the average amount of hours entered per project by the specific user pulled. I know how to set the Hours column in the report to Average but I do know how to tell it to do it by week.
What do I need to add to this Text Mode to tell the Hours Average to average the hours weekly?
aggregator.displayformat=doubleAsInt
aggregator.function=AVG
aggregator.namekey=hours
aggregator.valuefield=hours
aggregator.valueformat=doubleAsInt
linkedname=direct
namekey=hours
querysort=hours
textmode=false
valuefield=hours
valueformat=doubleAsInt
The filters I have chosen are:
Hour >> Entry Date >> This Year
Hour >> Owner ID >> John Doe
Project >> Type of Project >> Seasonal
