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"