Avi S.

Commented on Comparing Daily Homepage Views with 4-Week Average...·Posted inCommunity Questions

Avi S.

·

Disappointed to hear that - that should be doable. I wonder if the Mixpanel Product folks have a solution?

1

Commented on Comparing Daily Homepage Views with 4-Week Average...·Posted inCommunity Questions

Avi S.

·

Can you expand upon the instructions or point me to the right place to read more. I have an existing report created which compares the values to the values from the previous week and I would like to modify the second value to an average of the 4 previous weeks on that day of the week?

Posted in Community Questions·

Avi S.

·

Comparing Daily Homepage Views with 4-Week Average in Mixpanel

I am interested in creating a report which compares a data element from the previous day (ie. Homepage Views) to an average of the 4 previous weeks of that same day. For example, if yesterday was Monday, I would want to see a report which showed Monday’s Homepage traffic as compared to an average of last Monday, plus two weeks ago Monday, plus 3 weeks ago Monday plus four weeks ago Monday, averaged out. Can that calculation be done in Mixpanel? If so, how? Please advise.

5Comments

1

Posted in Mixpanel Bot·

Avi S.

·

Creating a Mixpanel Report to Compare Daily Homepage Views with Weekly Averages

I am interested in creating a report which compares a data element from the previous day (ie. Homepage Views) to an average of the 4 previous weeks of that same day. For example, if yesterday was Monday, I would want to see a report which showed Monday’s Homepage traffic as compared to an average of last Monday, plus two weeks ago Monday, plus 3 weeks ago Monday plus four weeks ago Monday, averaged out. Can that calculation be done in Mixpanel? If so, how? Please advise.

2Comments