Formula - Calculating monthly data based on weekly data


Weekly offsets - Calculating monthly data based on weekly data

Steps:

  1. Create a new measurable by clicking in the + sign in the top right corner of the Scorecard tile or in the “edit meeting” section. 
  2. Fill in the name of the measurable, select your goal, click on the Formula checkbox on the right side of the screen. 
  3. Type in the measurable’s name in which you want to base your calculations off four times (4) and add a plus sign (+) between each of them. (Eg. Measurable1 + Measurable1 + Measurable1 + Measurable1) 
  4. Leave the first measurable as it is and apply an offset on three of them by clicking on the carrot/arrow icon next to the measurable’s name and type in -1, -2, and -3. (That’s how you go back in time for 1 week, 2 weeks, and 3 weeks)

Video

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.