Expand my Community achievements bar.

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
Community 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
Community 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