Launch, grow, and unlock your career in data

July 26, 2017

Workout Wednesday: Order Analysis with LODs

Pretty straight forward Workout Wednesday this week. Here are Emma's requirements:

  • The first chart should could the number of customers by the number of orders they have made.
  • The first chart should have its bars coloured blue for 10 orders and above.
  • The title and tooltip should match as well. The title and tooltip changes as you select a Region.
  • The bottom chart (Top 10 products) should be filtered by the Region also. The top 10 products should change depending on the Region you select.
  • When you click on a bar in the top chart it should also filter the top 10 products.
  • The title and tooltip on the second chart should also change when you select a Region.

For the first chart, I used a FIXED LOD to count the number of orders per customer. I then created a parameter for selecting the region. To ensure my FIXED LOD would use the filter I built off the parameter, I made sure to put it into context.

But I don't want to give away all the hints. Give it a go yourself. You can download the data here. Click on the image below for the interactive version.


  1. Andy,

    There's a small "gotcha" in this one... look at the "header" for Orders by Customer. It jumps from 16 to 20 because there is some missing data.

    I can think of at least two ways to fix this (and I only noticed it because I ran into this issue recently where not showing the gaps presented some bad problems.)


    1. True, but I matched the requirements of the challenge. :-) I would fix it by making the axis continuous, changing the field to number (decimal) and setting the size of the bars to fixed.

    2. I've fixed it Steve. I set the fixed size to .9 to add some width between the bars. Thanks for the feedback!

  2. Hi,
    Just stumbling upon this, cool challenge! I was looking for something like this. FYI when I click on a bar in the top chart I get-
    "The top 10 products bought by customersNull"

  3. I'd expect the client would want, when the top selection is "All" for a stacked multi-color horizontal bar chart, central is orange, etc. Then when the selections are made those colors are re-used. Cheers!

  4. Also, the X customers made 10+ orders could be a single horizontal bar chart (would need to be scaled to All) with the same color coding.