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

1st column as Order number
2nd column as Shipping days
3rd 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 3rd column.

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

More examples:


For more challenges: Click Here

Experiment… Observe… Learn…