Do you feel that you are Tableau Expert? Then try this challenge 18

Hello All…

Here I am coming with very complex challenge. Let me see how you will solve this challenge. 

Don’t forget to share your solution with me. Please send your solutions to suresh.n2008@gmail.com

Look at the dataset below
Category
Date
Time available
Allocation Code
Category 1
1/1/2017
24
Calendar Time
Category 1
1/1/2017
22.46564641
Planned delay
Category 1
1/1/2017
21.65061065
Unplanned delay
Category 1
1/1/2017
16.62751987
Break
Category 1
1/1/2017
16.25161727
Unknown
Category 2
1/2/2017
24
Calendar Time
Category 2
1/2/2017
22.46564641
Planned delay
Category 2
1/2/2017
21.65061065
Unplanned delay
Category 2
1/2/2017
16.62751987
Break
Category 2
1/2/2017
16.25161727
Unknown
Category 3
1/3/2017
24
Calendar Time
Category 3
1/3/2017
22.46564641
Planned delay
Category 3
1/3/2017
21.65061065
Unplanned delay
Category 3
1/3/2017
16.62751987
Break
Category 3
1/3/2017
16.25161727
Unknown

Note: Data might be same for Category 1, Category 2, and Category 3. Filter for Category 1 and build below chart.

DO NOT modify above dataset to solve this challenge. Use same and try to solve



By seeing this chart, itself you can understand what we are showing. If not please follow below explanation.
  • Total Calendar Time is 24 hours. That is first bar in above chart.
  • 1.53 hours is difference between calendar Time and Planned delay. If you see that bar is starting from 24 hours (top to bottom) and ending at 22.45 hours. The height of the bar is 1.53 hours.
  •  0.82 hours is difference between Planned delay and Unplanned delay. But it will start from end of Planned delay bar.
  • Similarly, for Break and Unknown bars. Difference from previous value.
  •  Now whatever remaining is there, should display as Remaining bar.

Go through chart clearly, you will understand the challenge.

 For more challenges: Click Here
Experiment… Observe… Learn…