May 12, 2016

The Data School Gym - Timeline Pareto Chart

Another Data School Gym challenge for you. Today Jonathan MacDonald reached out to me with a question. I’m glad he reached out because I’m constantly asking him question. He asked:

How can we create a timeline Pareto chart? That is, we need to calculate the cumulative sales for a dimension from it’s first sale until it’s most recent, but the time has to be expressed as a % of cumulative days.

So, here’s the challenge for you. Create this chart below. It’s based on Superstore Sales and there are no big tricks. Just see if you can do it. Some hints:

You will need an LOD calc for the x-axis.

Include a single select parameter for the dimensions. Each line on the chart represents one element of the selected dimension.

Include an option to highlight a specific element within the dimension selected.

I’ve disabled the download option on the workbook so you can’t cheat. Tweet me when you think you’ve figured it out.