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

[ErikaWe]

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'

[SarahNa]

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!