Analytics - Support for Grouped Average in a Search

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"