2020 Week 15: Can you create a chart with a dynamic week start?

Hello Everyone!  First – I want to say that I hope you and your loved ones are happy, healthy, and safe during this time.  It’s amazing to think when I posted my last workout just 4 weeks ago, that the world (at least mine) looked completely different.

I want you to know that you’re all in our thoughts and we are so appreciate and grateful for the continued participation we’ve seen.  It’s unbelievably impressive how many of you have taken this opportunity to focus even further on your data skills.  You have my admiration.

This week’s challenge is another one that is influenced from my own work.  I’ve taken the original ask and distilled it down a bit.  My goal being to ensure you each have the opportunity to solve this within a short timebox.

Onto the fun part and the challenge!  This week I’d like you to construct a line chart that allows for the start day of a week to dynamically change, based on user input.  It also allows the user to determine the number of previous weeks that should be used in comparison.

The genesis of this ask came from the perspective of trying to understand how high and low points change throughout the course of the week and also trying to better understand a chunk of 7 days at a time.  In an ever changing climate, the goal was to compare the most common “weeks” to each other, and more specifically, be able to articulate that.

A great example would be to say, “we made this change on Wednesday” and here’s how the next 6 days of the week behaved.  It becomes a bit easier to understand the trend if the lines are unbroken by those 7 day periods.