Hi, we have a log that contains the amount of times any specific message has been sent by the user in every session. This log contains the user's ID (data.entity-id), the message ID (data.message-code), message name (data.message-name) and the total amount of times it was sent during each session (data.total-received).
I'm trying to create a table where the 1st column shows the User's ID (data.entity-id), then each column shows the sum of the total amount of times each message type (data.total-received) was received. Ideally I would be able to create a dashboard were I can have a list of the data.message-code's I want to be used as columns.
Example data:
data: {
entity-id: 1
message-code: 445
message-name: handshake
total-received: 10
}
data: {
entity-id: 1
message-code: 269
message-name: switchPlayer
total-received: 20
}
data: {
entity-id: 1
message-code: 269
message-name: switchPlayer
total-received: 22
}
data: {
entity-id: 2
message-code: 445
message-name: handshake
total-received: 12
}
data: {
entity-id: 2
message-code: 269
message-name: switchPlayer
total-received: 25
}
data: {
entity-id: 2
message-code: 269
message-name: switchPlayer
total-received: 30
}
Ideally the table would look like this:
Entity-id | handshake | switchPlayer
1 | 10 | 42
2 | 12 | 55
Is this possible? What would be the best way to store the message-code in a dashboard?
Thanks!
... View more
