Quick Tip: You can add a column to a project view to see the total number of issues in each project. | Community
Skip to main content
kynabaker16
Adobe Employee
kynabaker16Adobe Employee
Adobe Employee
September 21, 2021
Question

Quick Tip: You can add a column to a project view to see the total number of issues in each project.

  • September 21, 2021
  • 3 replies
  • 1945 views

To see the total number of issues in each project, add the following text mode code to a blank column in your view:

valuefield= totalOpTaskCount

linkedname=direct

valueformat=int

displayname=Total Issues

textmode=true

querysort= totalOpTaskCount

"Like" this post if you find it helpful!👍

To find all previous Quick Tips, go here and view the Discussions tab.

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

    3 replies

    Kundanism
    Kundanism
    Level 10
    September 22, 2021

    Hi @Kyna Baker - inactive‚

    I tested the above text code in project ad task view, but not visible. Could you please help by rechecking this?

    Mvh

    Kundan.

    MoniqueEvans
    Community Advisor
    MoniqueEvansCommunity Advisor
    Community Advisor
    September 22, 2021

    I use this field on my own Project Reports and can confirm it works as a project view column. You can try adding one more line to it but it shouldn't make a difference

    namekey=totalOpTaskCount

    Kundanism
    Kundanism
    Level 10
    September 22, 2021

    Thanks @Monique Evans‚ and @Kyna Baker - inactive‚

    It works, can we add a condition such as to highlight with colour if no. of issues are more than 1.

    Also, condition such as only active issues for example.

    Mvh

    Kundan.

    kynabaker16
    Adobe Employee
    kynabaker16Adobe EmployeeAuthor
    Adobe Employee
    September 22, 2021

    I'm glad you got it to work Kundan. This will only work in a project view, not a task view, so I'm glad you tested it again.

    Kyna

    Kundanism
    Kundanism
    Level 10
    September 23, 2021

    Hi @Kyna Baker - inactive‚

    Any recommendation, how can we add a condition such as to highlight with color if no. of issues are more than 1.

    Also, condition such as only active issues for example.

    Mvh

    kundan

    kynabaker16
    Adobe Employee
    kynabaker16Adobe EmployeeAuthor
    Adobe Employee
    September 23, 2021

    Hi Kundan,

    You can add a column rule to your totalOpTaskCount column, and do that in text mode to get those conditional formatting to show up.

    If you want to see the open issues, just use the Number of Open Issues field, which doesn't require text mode.

    Kyna

    C
    CatherineKe
    Level 5
    January 6, 2022

    @Kyna Baker - inactive‚ Thanks for this! It is very helpful.

    To go one step further, can I aggregate the average number of issues in a grouping? (by year and month, for example)

    kynabaker16
    Adobe Employee
    kynabaker16Adobe EmployeeAuthor
    Adobe Employee
    January 7, 2022

    Hi Cathy,

    I tried to ask people smarter than me for help and they had a couple of questions/thoughts.

    You can “group” by year or month, but that won’t give you an average. It will give you exactly all the issues in that grouping based on a date. For example, you can group on the Entry Date field by month and see groupings of all the issues with Entry Dates in the same month. But you're not going to see an average of anything.

    Does that help? If not it would be nice if you could explain what you're trying to do in more detail. An example of a report you would like to see would be helpful so we can give some suggestions.

    Thank you!

    Kyna

    C
    CatherineKe
    Level 5
    January 11, 2022

    Hi @Kyna Baker - inactive‚ I have created an Issues report that shows the number of Issues that were reported on Completed projects.

    Filters:

    Project>>Status = Complete

    Groupings:

    Project>>Actual Completion Date (Year)

    Project>>Actual Complete Due (Month of Year)

    Project>>Name

    It is showing me only the projects that had issues filed on them, but what I really want is a report that will show me ALL completed projects, along with the number of issue that were filed on each project (which may be zero in some cases). From that, I want to calculate the Average Number of Issues for the completed projects, and be able to chart that.

    I envision it would look this screenshot, which is the chart from my Issues report, showing the total number of issues on completed projects - but instead of "Record Count" it would be the Average Number of Issues.

    Terms & ConditionsAccessibility statement

    Loading footer...