Daily average of the current week

  • 29 June 2017
  • 1 reply

Is there a way to calculate the average daily of let’s say “bookings” per month but mainly be able to calculate the avg. monthly of the current month so far. Would it be possible to have the daily avg. weekly as well?

I have a weekly report and I would like to be able to see the daily avg. of every week including the current week even if it has only passed 4 days.

Thanks a lot!

1 reply

Userlevel 3

Hey @Maria_Gomez, you can do this with an average measure if you already have a daily count represented as a dimension. If that’s not the case, I would recommend talking to your developer team to get the “average daily measure” set-up.

The granularity of this measure would then be dependent on the dimensions included in the report. For example, if we include a month dimension, the average measure would compute per month, and so on. Let me know if you have any other questions!