Bar Chart with project count and issue count when my custom field = Yes. | Community
Skip to main content
ErikaWe
Level 2
Sep 23, 2020 1:16 PM UTC
Question

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

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

    SarahNa
    Level 6
    Sep 23, 2020 2:50 PM UTC

    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!

    Translate
    Terms & ConditionsAccessibility statement

    Loading footer...