Formula - Year over year ratio


Details:

Note that this is dividing the current week's value by the value from 52 weeks ago. See the above formula for details on offsetting the week.

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 two times (2) and add a division sign (/) between them. (Eg. Measurable1/Measurable1) 
  4. Leave the first measurable as it is and apply an offset on the second measurable by clicking on the carrot/arrow icon next to the measurable’s name and typing in -52. (That’s how you go back in time for 52 weeks or the equivalent to a year)
  5. If you want to create a percentage (%) out of it, all you need to do is to apply a parenthesis (one at the beginning of the formula and one in the end) and multiply that by 100. 

Video

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