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:
- Create a new measurable by clicking in the + sign in the top right corner of the Scorecard tile or in the “edit meeting” section.
- Fill in the name of the measurable, select your goal, click on the Formula checkbox on the right side of the screen.
- 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)
- 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)
- 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.
