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…