Skip to main content
Good Morning-





 















I’m working on some data validation for our dashboards and


noticed something funny. 















 















When I complete a search in Administration/Mass Edit, I


receive 22 results (seen below):















 

















In the report I built to reflect this, I am showing 17 Risk


CTAs in the “Total Open Risk CTAs by Owner”:















 

















When I click on that graph, I see all 22 Open Risk CTAs:















 

















 















Here is the report logic:















  

















 















Am I reading this


incorrectly?  With the way it’s built out


is the graph only showing the count of accounts that have risk CTAs, and then


when you click on the graph all the risk CTAs are populated?















 Thanks! 


















-Jim
I can't tell from your screenshot exactly what the Show field is but my hunch is that it is Account ID.  That would mean that you are counting the distinct accounts that have a CTA matching the criteria.  If you instead use CTA ID or something else unique per CTA then you will get the count you want.  Note that when you are joining objects together (as you do with Data Spaces and as we always do with Account and Customer Info) it can be easy to get the fields mixed up.  

Hi James, Hope @karl answered your question. Let us know if you have any further queries.





Thanks for posting 

Reply