How to calculate average number of deliveries | Community
Skip to main content
December 8, 2021
Solved

How to calculate average number of deliveries

  • December 8, 2021
  • 1 reply
  • 956 views

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by david--garcia

One way would be: query broadlogrcp count by @1716897 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)

 

 

 

1 reply

david--garcia
david--garciaAccepted solution
Level 10
December 8, 2021

One way would be: query broadlogrcp count by @1716897 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)