Workout Wednesday – Week 16: Sales for the last N vs. same time previous year

Sorry for the late post.

I’m filling in this week at the last minute. Here is this weeks workout.

• Dashboard size is 700 x 600; tiled; 1 sheet
• Use a date parameter to select a select end date, limit it to all days in 2017.
• Use a parameter to select the period type – limit it to day, week, and month.
• Use a parameter to select the number of periods to go back – limit it from 1 to 12.
• The bars show the total sales for the last complete period. This means if 5/12/2017, month, and 1 is selected you will see sales from 4/1/2017 thru 4/30/17.
• Add sales for the same period to label.
• Compare this to sales over the same period from 2016.
• Add a blue arrow up if sales are up compared to 2016.
• Add a red arrow down if sales are down compared to 2016.
• Show the difference in sales over these time periods. Make sure to show no negative signs. The arrows will indicate the change.

Dataset

This week uses the superstore dataset.  You can get it here at data.world

Share

After you finish your workout, share on Twitter using the hashtag #WorkoutWednesday and tag @AnnUJackson, @LukeStanke, and @RodyZakovich.  (Tag @VizWizBI too – he would REALLY love to see your work!)

Also, don’t forget to track your progress using this Workout Wednesday form.

3 thoughts on “Workout Wednesday – Week 16: Sales for the last N vs. same time previous year”

1. Question about the [3. Last Full End Date] formula –

The formula DATETRUNC([Level], [Date] + 1) – 1 works, unless you choose the last date of a [2. Level] in the [9. Date] parameter. For instance, Choose “6/30/2017” for [9. Date], and [Last Full] = 6/30/2017, but any other date in June and [Last Full] = 5/31/2017.

Should the formula simply be DATETRUNC([Level], [Date]) – 1 ?

2. John Trefethen

Had fun doing this one, in part because I could actually figure it out! Always fun to download the actual copy and see how you did things differently. Appreciate you putting these out here each week!

John

Scroll to Top