Average (Actual Duration) on Reports

  • 0
  • 1
  • Question
  • Updated 8 months ago
  • Answered
Hi,

I have a "text-multiple choice" field with drop down options "revise, reuse, modify, new". I am pulling up a report grouped based on the above options. The report shows up only the "total" of the "Actual Duration" for each group. Is there a way, I can make the report to show "averages" instead of "total" on the "Actual Duration". See screen shot:


The report customization gives me only option to "hide all total/averages" (and, not to show "averages")

I would like to see the result of on an average how many days it takes to finish a "new or revised, or modify" project.

Please help. Thanks.
Photo of Kingsly SD Samuel

Kingsly SD Samuel

  • 776 Points 500 badge 2x thumb

Posted 8 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,296 Points 50k badge 2x thumb
Easy,
Edit the field properties for Actual Duration to uncheck show Totals and to check off To show Averages.
Photo of Kingsly SD Samuel

Kingsly SD Samuel

  • 776 Points 500 badge 2x thumb
The "Actual Duration" is a "numeric-formula field" to show actual days that it took to finish the project from start to complete. And, I don't see the option you are saying in the field properties, Mark.
Photo of Kingsly SD Samuel

Kingsly SD Samuel

  • 776 Points 500 badge 2x thumb
Ignore me, found it. Thank you.
Photo of Evan Martinez

Evan Martinez, Community Manager

  • 8,774 Points 5k badge 2x thumb
Hi Kingsly,

It might seem a bit counter-intuitive when you are on a report but that option to show an Average or a Total is controlled on the field settings. If you open up the field settings for Actual Duration under the display options you will find the checkbox to 'Display an average of this field in reports'. Enabling this will cause the averages to show on report, then you can also disable the Totals if  you would like. I hope this information is helpful. 
Photo of Kingsly SD Samuel

Kingsly SD Samuel

  • 776 Points 500 badge 2x thumb
yes, found it. Thank you both it is just above the formula bar.
Photo of Kingsly SD Samuel

Kingsly SD Samuel

  • 776 Points 500 badge 2x thumb
Just wondering, is there a better format of report (not a table, but a chart of some type) would help me display it better? Any thoughts.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,296 Points 50k badge 2x thumb
I would try a line chart first and use the group as the “series”. The x would Bev the date grouped by month or by week. The y would be the duration as an Average.
Photo of Kingsly SD Samuel

Kingsly SD Samuel

  • 776 Points 500 badge 2x thumb
Thank you. That actually worked wonderful.