0 Replies Latest reply on Sep 13, 2012 1:27 PM by Jim Stanley

    Help with counting distinct non-null data

    Jim Stanley

      I am a novice with Tableau (and SQL) and need help calculating a data point based on the structure of my database. What I need to do is count distinct people based on a string of events they take. Here's a sample of the data structure (attached).


      What I want to know is how many people (INBOUNDID) uniquely did both event #1 and event #2. As people do event #2 more than once. My challenge and limit of knowledge is that the INBOUNDID is a generated ID based on event #1, and I can't figure out the calculation that will allow me to count only distinct people that did event #2.


      The end result (or one) would be a cross tab showing:


      Total event 1:   1000

      Total event 2:   >1000

      Unique event 2: <1000


      Basically a unique conversation rate.


      Any help appreciated!