Average Weekly Hours | Community
Skip to main content
Level 2
November 14, 2022
Question

Average Weekly Hours

  • November 14, 2022
  • 0 replies
  • 450 views

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.