Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

How to calculate average number of deliveries

Avatar

Level 1

what’s the best way to calculate the average number of email deliveries to customers on a weekly basis?

1 Accepted Solution

Avatar

Correct answer by
Employee Advisor

One way would be: query broadlogrcp count by @ID group by DateOnly(@eventDate), refine query by @eventDate on or after DaysAgo(7), add enrichment then use avg() expression on the @count ( such as avg(@count)

 

David__Garcia_1-1638945254194.png

David__Garcia_2-1638945268384.png

David__Garcia_3-1638945302244.png

David__Garcia_4-1638945519630.png

 

 

View solution in original post

1 Reply

Avatar

Correct answer by
Employee Advisor

One way would be: query broadlogrcp count by @ID group by DateOnly(@eventDate), refine query by @eventDate on or after DaysAgo(7), add enrichment then use avg() expression on the @count ( such as avg(@count)

 

David__Garcia_1-1638945254194.png

David__Garcia_2-1638945268384.png

David__Garcia_3-1638945302244.png

David__Garcia_4-1638945519630.png