Skip to Content
0
Jan 29, 2015 at 10:29 PM

Display dimension data in multiple columns

14 Views

Hi Guys,

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.


Thanks

Dilip

Attachments

1.JPG (24.2 kB)
1.JPG (17.0 kB)