Bar Chart with project count and issue count when my custom field = Yes. | Community
Skip to main content
E
ErikaWe
Level 2
September 23, 2020
Question

Bar Chart with project count and issue count when my custom field = Yes.

  • September 23, 2020
  • 1 reply
  • 419 views

I can do a project report and get the bar = project count

Then I used the totalOpTaskCount to get a column in the report with count of All Issues

But I can't figure out how to sum the Issue count ; only counting the issues 'IF custom field on Issue = Yes'

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

    1 reply

    S
    SarahNa
    Level 6
    September 23, 2020

    Hey Erika,

    You will need to create a calculated field on the custom form in order to use it in a chart. I think this should work:

    IF(CONTAINS("Yes",{test field}),totalOpTaskCount,"")

    Just replace the 'test field' with your custom field name.

    Hope this helps!

    Terms & ConditionsAccessibility statement

    Loading footer...