This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.
As others did, I recognized the formula as a least-squares regression line, so I also used the Linear Regression tool to generate the trend values. For this particular problem, the standard tools were much faster than the predictive tools.
Also, as others did, I packaged the chart creation in a macro, so it could be reused for multiple KPIs. Of course, in this case, there isn't a real business reason to let the user pick between predictive vs. standard tools, since they produce the same output! I just wanted to keep it all in one workflow, since the spirit of the challenge was to use standard tools. Plus, it's always good to get some practice with the Detour tools!