Looker Connect Training

Help Center

Documentation

Community

Cloud Certifications

Question

Daily average of the current week

  • 29 June 2017
  • 1 reply
  • 581 views
M

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

paola
Rank
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!

Reply


Terms of Service