I need some help finding the correct direction to go in. Here is the problem:
I have a dataset of unique devices, and each device has a count of the number of service tickets opened in each of 4 categories. Here is some sample data.
For each device ID separately, I need to determine if the ticket types are clustering or grouping in some way, and if so, which types are most common. A cursory look at these data might suggest that:
- ID #1: there is grouping, Type 1 is most common
- ID #2: does not appear to be grouping
- ID #3: grouping, Type 1 and Type 3 most common
- ID #4: grouping, Type 4 is most common
I realize that my definition of 'grouping' is very lax, and that is where I need assistance.
Should I be looking at particular distance metrics? perhaps proportional? Any advice would be much appreciated.