Customer(s) who requested this
Ubisoft
Use cases
-
what is the average number of days that users played
-
what is the average amount of hours that users played
New question word: "Average count of" -> groupedAvg(id)
New pivot options:
-
"year" -> ['time.year']
-
"month" -> ['time.year', 'time.month']
-
"day" -> ['time.year', 'time.month', 'time.day']
-
"hour" -> ['time.year', 'time.month', 'time.day', 'time.hour']
-
"minute" -> ['time.year', 'time.month', 'time.day', 'time.hour', 'time.minute']
Example
"Average count of rounds played per user per day"