Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

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

Avatar

Level 2

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'

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Reply

Avatar

Level 7

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!