3 Replies Latest reply on Apr 20, 2018 6:33 AM by Deepak Rai

    Distinct Count of column values showing just 1

    waqar ahmad

      Hello Everyone,


      Weird issue at hand and i apologize in advanced for not being able to share a file. I will try my best to explain via screenshots here. The issue I'm seeing should be an extremely easy feat.. but I cannot figure out the reason for the life of me.


      In the "Resource by Project" view what you're seeing is the action filter result that drills down from the pie chart above.

      As we can see currently selected is the Cardiovascular Specialty Solutions Segment in which are 11 projects. In order to get this 11 I applied a CNTD on the project ID's that are associated with each one of the projects in the list. The issue I'm having is that when I apply the same CNTD to the ID's and attach that as a detail within the "Resource by Project" title, I see the number 1. Thats it.. 1 whereas we can clearly see that there are 11 projects.


      I went ahead and changed the CountD(ProjectId) to just Count(ProjectId) and now I'm seeing something I've never seen before.. # of projects : 1 to 7 .. I dont know where the 1 to 7 came from .. all I'm trying to see are my simple totals that should match the 11 that shows up within the pie chart.


      Your help is greatly appreciated. I apologize for any confusion I may cause.

      Thank you,