How can I count total issues on a project report? I see code for open issues but cannot figure out what it would be for all issues. | Community
Skip to main content
E
EliseCr
Level 2
September 3, 2020
Solved

How can I count total issues on a project report? I see code for open issues but cannot figure out what it would be for all issues.

  • September 3, 2020
  • 2 replies
  • 16668 views

I found count for open issues and tried different permutations in text mode with no success.

This is code for open issues:

valuefield=numberOpenOpTasks

querysort=numberOpenOpTasks

valueformat=int

displayname=

linkedname=direct

namekey=numberOpenOpTasks

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

    Hi Elise -

    Try this:

    displayname=

    linkedname=direct

    namekey=totalOpTaskCount

    querysort=totalOpTaskCount

    valuefield=totalOpTaskCount

    valueformat=int

    2 replies

    C
    CoreyAu1
    Level 2
    September 8, 2020

    The only workaround I've figured out is to group them. When you group things, the system tallies the grouped items together and puts a total in the bottom right corner. Not exactly what you're looking for, but maybe could work until you figure out the text mode.

      S
      SarahNaAccepted solution
      Level 6
      September 9, 2020

      Hi Elise -

      Try this:

      displayname=

      linkedname=direct

      namekey=totalOpTaskCount

      querysort=totalOpTaskCount

      valuefield=totalOpTaskCount

      valueformat=int

        E
        EliseCrAuthor
        Level 2
        September 9, 2020

        @Sarah Nau‚ Thank you so much! This is exactly what I needed. I didn't realize I needed both total and count. I spent over a week trying to get the correct terminology from Workfront and still haven't received assistance so this is really helpful.

        S
        SarahNa
        Level 6
        September 9, 2020

        Happy to help!! 😊

        Terms & ConditionsAccessibility statement

        Loading footer...