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…

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

Hello all…

Here I am coming with an interesting challenge. It might look simple. Yes, all my challenges are simple. Sometimes you might guess trick sometimes you may not. Lot of people succeeded in guessing trick for challenge 16. Now it’s time for challenge 17. I am sure it’s not as simple as challenge 16.

Note: Surprisingly this is working fine in 9.1 version. It won’t be a challenge in 9.1 version. But when I tried this in 10.1 version I felt it like a challenge.

Look at the data set below. It just monthly sales data for 2016 and 2017.

Year	Month	Sales
2016	Jan	50
2016	Feb	45
2016	Mar	60
2016	Apr	65
2016	May	56
2016	Jun	40
2016	Jul	70
2016	Sep	48
2016	Oct	35
2016	Nov	60
2016	Dec	70
2017	Jan
2017	Feb	30
2017	Mar	80
2017	Apr	50
2017	May	60
2017	Jun	70
2017	Jul	50
2017	Sep	60

Note:

·         I don’t have sales for Jan 2017 and Sales data is there till Sep 2017.

·         Copy and paste above data to solve this challenge.

Below you can see the line graph draw using given data

                                   

I would like to show cumulative (Running total) sales line chart. You can see below

Now the challenge starts…

You can see that orange line indicates 2017 sales. In data set I don’t have data after Sep month in 2017. As I am doing cumulative or running sum so it is showing 400 after Sep also. I don’t want to show 400 for all other months which does not have data and orange line should start from Jan.

So, you should get solution like below.

 For more challenges: Click Here

Experiment… Observe… Learn…

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

Hello All… here I came with new challenge which will be very interesting and useful. We all know about highlight table and how it looks. Did you ever tried highlight table like below?

It’s cool and awesome. Isn’t it?

I know we were end up with highlight tables showing like below.

This is general default highlight table. If we place KPI color column, then it might look like below

Here I got one idea to make this color boxes consistent width and height. After implementing that I got the view which you seen in first image.

******************************************************************************

Many people have approached me to provide solutions for these challenges.
I felt that if I provide solution you may not show interest to solve these challenges and then thought of making solution videos and hence the delay in sharing. Since, time is not permitting to work on the videos, I have finally sharing the solution workbooks. These solution links can be found in real time challenges page. I apologies for delay in responding to mails and chats as I got busy with my other priorities

******************************************************************************

For more challenges: Click Here

Experiment… Observe… Learn…

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

This challenge looks very simple. If you try to solve then you will understand what’s the challenge here.

Use Super Store dataset to solve this challenge.

I have 4 filters in above chart. If I change Year, Segment and Category Then Sales and profit values will change. But if I unselect any of value or values from Sub-Category filter then Profit will become Zero. Only sales numbers will change. See below

In above scenario, I only changed Year, Segment, and Category filters. Sub-Category filter showing all selected. If I change Sub-Category filter, then Profit should be zero. See below

Here challenge is simple. When you select all values in Sub-Category then profit should show. If you unselect single or multiple values, then profit should be zero. Very interesting challenge try it.

Example 1:

Example 2:

Example 3:

For more challenges: Click Here

Experiment… Observe… Learn…

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

Using below data solve this challenge.

Order Number	Shiping Days
A001	1
A002	2
A003	5
A004	10
A005	25
A006	13
A007	7
A008	6
A009	3
A010	50
A011	100
A012	65
A013	70
A014	85
A015	90
A016	110
A017	45
A018	150
A019	130
A020	125

Note: you can copy and paste this data into excel and start solving this challenge.

I want to show report like below.

In above report we are showing

1^st column as Order number

2^nd column as Shipping days

3^rd column is calculated in Tableau. You can see logic below.

Median days calculated after excluding shipping days more than 60 in this example.

I used parameter to enter limit value. Here I entered as 60. So, I am considering shipping days less than 60 only.

After excluding shipping days more than or equal to 60. We must calculate median days. you can see below.

So, median days for this above data is 7. This value we are showing in 3^rd column.

4^th column is nothing but difference between 2^nd and 3^rd column.

More examples:

For more challenges: Click Here

Experiment… Observe… Learn…