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