Expand my Community achievements bar.

The Community Ideas review for H1 2025 is out now, see which ideas our Product team prioritized and let us know your thoughts.

Mark Solution

This conversation has been locked due to inactivity. Please create a new post.

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!