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…