Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
To start I have a 13 week 90D Turnover with the general expression below. It pulls from view where it lists only those in the 90D window and calculates turnover for each corresponding trailing 13 weeks.
Sum({<RelativeWeek = {">-14<0"}>}[RetentionTerms.TermCount])
*52
/
Sum({<RelativeWeek = {">-14<0"}>}[RetentionHires.Base])
I need help creating a new graph showing a 13 week trend but now cumulative from the start of the data (in this case beginning of 2024) where each week layers onto the next with a cumulative effect. By the end the 761 total from 8/12 would be more like ~25,000 starting from week 1 of this year and 8/5 would show ~24,300. Same logic for the terms. This view would take out any recent noise.
