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

Hello All…

Here I am coming with new challenge. Use below dataset and solve this challenge.

Region	Number of Customers	Number of Orders
East	2	0
East	3	1
West	9	0
West	3	1
West	1	2
South	24	0
South	6	1
South	10	2
South	3	3
South	5	More Than 3
North	6	1
North	4	2

 Using above data build below report in Tableau.

Note: Avg column is based on below calculation

Avg: sum (Number of customers * Number of orders) / Total Number of orders

Note: if number of orders is more than 3 then I am multiplying with 4. You can see Avg for South.

Avg for East: ((0 *2) + (1* 3)) / 5 = 0.60

Avg for North: ((1*6) + (2*4)) / 10 = 1.40

Avg for South: ((0*24) + (1*6) + (2*20) + (3*3) + (5*4))/48 = 1.15

Avg for West: ((0*9) + (1*3) + (2*1))/13 = 0.38

For more challenges: Click Here

Experiment… Observe… Learn…