Launch, grow, and unlock your career in data

March 21, 2018

Workout Wednesday: Sub-Category Sales Change in the Last Two Periods

No comments
Another Workout Wednesday in the books. This week, Curtis Harris created the challenge in Luke's absence. Why didn't I think of subs last year?

Find all of the requirements on the Workout Wednesday website. Essentially, you have to provide the user with a date filter and use that filter to display a barbell chart of sales up to the date selected for its month compared to the same days in the prior month.

What tripped me up most was creating the tooltips. I'm going to have to look at how Curtis did it, which I suspect was with LODs. I used LODs to get the sales based on the filter table calcs for the tooltips since all of the dimensions I needed were already in the view.

Give this one a go before downloading any of the solutions. You'll learn more by struggling through it.

No comments

Post a Comment