5 Replies Latest reply on Dec 25, 2015 12:18 PM by KK Molugu

    Educational Brain Teaser: Box & Whiskers Distribution applied to Time of Day

    Shawn Wallwork

      This comes from a post I worked on this past week. It took me a fair amount of time to work through all the issues involved, so I thought it might make a good Brain Teaser. Here's the chart you are trying to recreate:

       

      It shows a Box & Whisker distribution of the time of day when individual jobs finished. (Sample dataset attached.) As you will discover the tricky part is that Box & Whisker distributions cannot be applied directly to a Datetime field. Have fun!

       

      --Shawn

       

      SPOILER ALERT: The answer will be posted over on this thread, so don't go there if you want to work it out on your own.

       

      Box Whisker Plot along with Time of a Day in Y axis