Weekly Challenges
Solve the challenge, share your solution and summit the ranks of our Community!Also available in | Français | Português | Español | 日本語
IDEAS WANTED
Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA
I matched the styling fairly closely, but I didn't truncate the axes as it is definitely not best practice with bar charts...
Spoiler
Workflow
Output in ppt
WorkflowOutput in ppt
Nice!
Spoiler
At first, I thought about using predictive tools - linear regression in particular but couldn't get the line information out of it. So I solved it implementing the trend line calculations as attached to the challenge. then I went back to predictive and used the score tool to predict the values from the linear regression which gets the same result but with my custom macro I can easily write down the calculation for the trend line
Trend line implementation:
Trend line implementation:
Super challenge! Really enjoy the mathematical analysis. Always get new ideas and learn new ways to configure when playing with reporting tools.
