I'm stuck trying to figure the AVERAGE number of Issues per project. | Community
Skip to main content
C
CatherineKe
Level 5
January 3, 2022
Question

I'm stuck trying to figure the AVERAGE number of Issues per project.

  • January 3, 2022
  • 1 reply
  • 862 views

I need to create a report (chart preferably) that shows the average number of issues per project, by month, over a time period (last two years, for example).

I created an Issues report that allows me to chart the Number of Issues on completed projects each month.

I also created a Project report with a text mode column, which shows the total number of Issues on each project. I've only been able to figure out how to chart by the total number of closed projects each month with this report though, not by the number of Issues.

How can I calculate the average number of issues per project?

Can I chart this information?

Example: December 2021, we completed 90 projects, and had a total of 128 issues on those projects . I would like to chart that December 2021 Average Issues per Project as 1.42.

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

1 reply

skyehansen
Community Advisor and Adobe Champion
skyehansenCommunity Advisor and Adobe Champion
January 3, 2022

it just doesn't work to chart off textmode. You really need to create it as a calculated field and chart off that. Hopefully all your projects share the same custom form?

    C
    CatherineKeAuthor
    Level 5
    January 4, 2022

    @Skye Hansen‚ Most of the project use the same form, but there are some that use a different custom form. Can you tell me more about how I'd use that to get the average issues per project?

    Thanks!

    skyehansen
    Community Advisor and Adobe Champion
    skyehansenCommunity Advisor and Adobe Champion
    January 4, 2022

    I'm not sure what you're asking. But if projects are using different custom forms, you basically need to put the calculated field on each form. The calculated field will store the same number you are pulling up via textmode, but because it's now a custom form field, you can now show it in a bar chart which you can't if it is a textmode column (did that answer your question?)

    Workfront will allow you to run averages on that field per your grouping, which it looks like you want to group by planned completion date.

    You're looking for something like this, right?

      Terms & ConditionsAccessibility statement

      Loading footer...