In the Universe I have a table with the following dimensions UserID, Device Type, Time (see the sample data below). A user could have worked with a multiple devices over the period but can have only one at a time.
I need to create a report to find out whether the each user(user_id) had used a certain device type or not. If yes display the device type otherwise blank. The problem here is I have to display them in separate columns based on the device type. So basically in this case I need to display a column for each device type based for each user ID (something like this).
Not sure how this can be achieved. Any help would be appreciated.