Hi!
This is a difficult one to give a title but basically, here is what I am trying to do:
I have a dataset that combines a dataset of user profiles and a dataset of our assets that are assigned to each user. What this does is make it so every single entry for a user's individual assets gets its own row. So basically, if John Smith has a Laptop and a Mobile Phone, he'll have two complete rows like so:
User: John Smith | AssetType: Laptop | DeviceName: John's Mac | etc
User: John Smith | AssetType: Mobile Phone | DeviceName: John's iPhone | etc
What I really want this dataset to be is a high level breakdown of each user, how many assets they have, and how many of each type of asset they have. So theoretically, I'd like it to be something like this:
User: John Smith | Number of Assets: 2 | Number of Laptops: 1 | Number of Mobile Phones: 1
I can see where I can group up the rows by username and get a count of the AssetType, but I'd like to have columns in the dataset that break things down like the above example if possible. What sort of steps would I need to take to do something like that?
Any help is appreciated!