Question

Sum of events for each day over time

  • 16 November 2021
  • 0 replies
  • 10 views

Hi there.

We have a very particular problem:

 

We are using rolling averages in multiple insight views as some of our KPIs tend to spike heavily.

This is all good in theory however the rolling average is a simple average over the results of each day individually while not calculating the “weight” of the underlying number of events.

To give you an easy example:

Let’s assume we would calculate a conversion rate by comparing 2 events.

On Monday 2 users signed up and 2 executed the conversion event. The conversion rate for Monday is 100%

In Tuesday 100 users sign up and 1 executes the conversion event. The conversion rate for Tuesday is 1%.

The rolling average over both days would be 50,5 % while the actual conversion rate over both days would be 3 %.

 

This is all fine as this is how most rolling average functions work, but we would like to calculate the conversion rate for each day looking at the last 7 days.

 

Is there any way to sum up an event for each day looking at a certain time-frame?

For each date I want the sum of the event XY on that date and the 6 days prior.

This way I could calculate a weighted 7 day average.

 

Thank you very much!


0 replies

Be the first to reply!

Reply