Reporting by multiple events, pivoting on 'name'

General questions
1

I am logging multiple events with the name same ‘name’. For example

[category, action, name, value]
[“content”, “view”, “content ID”]
[“content”, “feedback”, “content ID”]
[“content”, “rating”, “content ID”, 4]

I want to create a report that’s a table pivoting on the content ID eg.

             |  views | feedback | rating | avg. rating
content ID 1 |   13   |  2       |  5     | 1.5
content ID 2 |  140   | 3        |  6     | 4.6
content ID 3 |  1     | 0        |   7    | 0.2

Is this possible?

2

I’ve just discovered the “pivot” option which does exactly what I want.

1 Like