Skip to main content
Topics#Tableau Desktop & Web AuthoringTableau Community Forums Member (Inactive)'s Question
Tableau Community Forums Member (Inactive) (Salesforce) asked in #Tableau Desktop & Web Authoring
Jul 26, 2018, 1:09 AM

LOD calculation not providing a unique count

I am noticing that the Dcount function isn't working correctly while calculating the role "Manager".  The attached dashboard shows 6 Unique Employee ID's for Adds and 3 Employee ID's for Terms but it should be 3 Adds and 1 Term for of a difference of 2.  The adds is IDs:13,24,49 and the Term ID is 66.  Please help!

 

IndustryRoleTypeStateEmployee IDReal EstateManagerAddVA13Real EstateManagerAddNC13EnergyManagerAddNY24EducationManagerAddOH49Real EstateManagerAddOH49ITManagerAddOH49Real EstateManagerTermsIL66EnergyManagerTermsIL66RegionalManagerTermsIL66

 

LOD calculation not providing a unique count

LOD Difference.twbx
2 answers
  1. Naveen Reddy (Cisco)
    Jul 26, 2018, 1:38 AM

    Hi Wendy,

     

    Check the below screenshots i have changed the calculation little bit

     

    Add LOD:

    Hi Wendy, Check the below screenshots i have changed the calculation little bit Add LOD: Term LOD:Difference Whats going wrong is : you are maintaining the same granularity as like detailed data that'

     

    Term LOD:

    pastedImage_1.png

    Difference

     

    pastedImage_2.png

     

    Whats going wrong is : you are maintaining the same granularity as like detailed data that's why you are getting the wrong numbers

     

    Hope this helps, Kindly mark this answer as correct and Helpful so that it will be helpful to others

     

    BR,

    NB

Write an answer...
0/9000