Can I calculate the average number of proof versions for a user? | Community
Skip to main content
C
CatherineKe
Level 5
January 26, 2026
Solved

Can I calculate the average number of proof versions for a user?

  • January 26, 2026
  • 3 replies
  • 31 views

I am currently using a document version report to show how many Approved proofs a user has for a certain period of time, along with the number of versions of the proof.

 

Can I calculate the average number of proof version for the user?

For example, in this screenshot, can I calculate the average number of proof versions from Kevin by totaling the “Ver” column and dividing the number of proofs (17)?

 

I’m very open to getting this information with a different type of report, if needed.

Thanks!

Best answer by IvanBebek-iX

Hi ​@CatherineKe ,

 

In order to solve this you need an aggregator, please refer to this documentation https://experienceleague.adobe.com/en/docs/workfront/using/reporting/reports/custom-view-samples/view-column-project-average-actual-duration-aggregated-grouping.

 

Can you try this and let me know if it works for you?

 

Best regards,
Ivan

3 replies

J
JenniferNe6
Level 2
January 26, 2026

I usually just export my report/data into Excel.  You could create a Pivot table and then refresh your data anytime you do a new export.  (short-term solve) Not sure if there’s a way to calculate the average in the report.

    Mikaela-Newell
    Mikaela-Newell
    Level 3
    February 6, 2026

    Maybe try a User Report? You could pull the User collection Documents and field lastVersionNum (see code below). Not sure how you’d reference the number of objects in the collection though in order to divide the sum...

    displayname=Proof Rounds
    listdelimiter=<p>
    listmethod=nested(documents).lists
    type=iterate
    valuefield=lastVersionNum
    valueformat=HTML

    (Obviously not a full answer, just brainstorming! This also doesn’t address how to filter by date range.)

      IvanBebek-iX
      IvanBebek-iXAccepted solution
      Level 5
      February 6, 2026

      Hi ​@CatherineKe ,

       

      In order to solve this you need an aggregator, please refer to this documentation https://experienceleague.adobe.com/en/docs/workfront/using/reporting/reports/custom-view-samples/view-column-project-average-actual-duration-aggregated-grouping.

       

      Can you try this and let me know if it works for you?

       

      Best regards,
      Ivan

        Terms & ConditionsAccessibility statement

        Loading footer...