Expand my Community achievements bar.

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!