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
  • 865 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!

    C
    CatherineKeAuthor
    Level 5
    January 5, 2022

    Yes, that's exactly what I'm trying to do!

    I'm getting to work on that now... thanks for the explanation, Skye.

      Terms & ConditionsAccessibility statement

      Loading footer...