Skip to main content
Question

Strange Reporting issue: Numbers are not matching up


james_whitehead
Forum|alt.badge.img
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

2 replies

karl_rumelhart
Forum|alt.badge.img+4
  • Helper ⭐️⭐️⭐️
  • 460 replies
  • July 29, 2018
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.  

sai_ram
Forum|alt.badge.img+1
  • Expert ⭐️⭐️
  • 3727 replies
  • August 14, 2018
Hi James, Hope @karl answered your question. Let us know if you have any further queries.

Thanks for posting 

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings