1 Reply Latest reply on Feb 3, 2016 8:44 AM by Andrew Ellison

    Counting individuals that overlap multiple categories

    Andrew Ellison

      Hello All,

       

      I have data with number of specialty categories (400+) that our customers can fall into. Each customer has a unique ID and can fall into multiple categories. I'd like to create a dashboard that shows the count of individuals overlapping in multiple categories. In my mind it would have be a heat map grid similar to the following:

       

      Category XCategory YCategory Z
      Category A1007255
      Category B1212986
      Category C549833

       

      Any ideas on how to go about calculating something like this out?

       

      Thanks!

       

      Andrew