I am trying to count the number of populated Resource fields per DEFECT_ID in order to use them as a grouping on a bar chart. Can someone please help me fix this? It is not working as intended. As you can see from the table below, the counts are not accurate. 4046 should show 4 but it shows 8.