Tableau Number Functions Assignment for Beginners

Here I am coming with assignment on Tableau number functions. This is very basic and fundamental assignment for beginners. Almost every body know functions in tableau. Lets see how they learned and understood.

After several posts I understood that people are more interest in solving problems and learning from them. It will add taste to learning process. So I decided to post assignments and challenges. I would like to initiate the thought process in their mind while solving this assignments and challenges. So that they will improve their self learning capabilities. Giving solution to problems is like temporary fix. After few days you may forgot solution. But Solving problems will stamp the process for long time. I am just feeling this is new way of teaching people.

Question 1:

I have Region wise Profit like below

Region   Profit

East         50

West      -20

South      30

North     -15

I want to show bar chart Like Below

What function you will use while making above chart?

Question 2:

I have data like this

Items     Cost

Item1      5.125

Item2      1.890

Item3      4.578

Item4      6.009

I want to show output like below:

Items     Cost

Item1      6

Item2      2

Item3      5

Item4      7

What function you will use to get above output?

Question 3:

I have data like this

Items      Cost

Item1       7.135

Item2       4.999

Item3       8.011

Item4       5.875

I want to show output like below:

Items      Cost

Item1       7

Item2       4

Item3       8

Item4       5

What function you will use to get above output?

Question 4:

How you will get Quotient and Remainders in Tableau?

55(Dividend) ÷ 9(Divisor) = 6(Quotient) and 1(Remainder)

See below examples to understand more:

13/5 will give Quotient: 2 and Remainder: 3

21/5 will give Quotient: 4 and Remainder: 1

Question 5:

What function you will use in Tableau to get 5^3 = 625?

Question 6:

I have Sum(Sales) like this: 50.1234 but i want to show only 50.

Which function and how you will use it to get this output?

Question 7:

I have Sum(Sales) like this: 6789.2345 But i want to show like this 6789.2.

Which function and how you will use it to get this output?

Question 8:

I have number like this: 12345 but i want to truncate this number to 12340.

Similar way Truncate above number to 12300.

Which function and how you will use it to get above output?

Question 9:

How to convert NULL values to Zero in Tableau?

Question 10:

How to Find Square Root in Tableau?

Example: Square Root for 625 is 25.

Question 11:

I have data like this

Items      Cost

Item1      5.125

Item2      1.821

Item3      4.572

Item4      6.019

I want to show output like below:

Items     Cost

Item1     5.120

Item2     1.820

Item3     4.570

Item4     6.010

What function and how you will use it to get above output?

Question 12:

I have Customers and Profit like below

Customers        Profit

Suresh                50

Ramesh             -20

Mahesh              40

Kishore               0

Rama                  0

Kirshna            -10

I want to show report like below:

Customers     Profit      Indicator

Suresh               50                1

Ramesh            -20              -1

Mahesh             40                1

Kishore              0                 0

Rama                 0                 0

Kirshna            -10              -1

What function you will use to show indicator column?

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

Here I am coming with real time challenge. Those who are interested can try this and test your knowledge.

Initially some body asked me to post real time challenges. I am getting good responses to these posts. These challenges are to test your knowledge. I am not challenging anybody here to solve. I am just alerting people by using sentence “Do you feel that you are Tableau Expert?”. If really solve my challenges you will become expert definitly. How you are thinking is very important while solving challenges.

Here we go with one more challenge:

In Above image at bottom, you are seeing 1,2,3….. 17. These are Number of Orders by Customer.

Color Indications:

Blue – Number of Customers does not return any Order. Means Zero Order returned.

Green – Number of Customers who returned only 1 Order.

Red – Number of Customers who returned only 2 Order.

Purple – Number of Customers who returned only 3 Order.

Explanation 1:

Now lets take bar which is showing 1 at bottom of the image.

Assume that 100 Customers placed only one Order. In that 100 Customers 92 people not returned any Order. But 8 People returned one Order.

Explanation 2:

Now lets take bar which is showing 12 at the bottom of the image.

Assume that 100 Customers placed 12 Order per each Customer. In those Customers 39 people not returned any Order. But 39 people returned only one Order, 17 people returned only 2 orders and 6 people returned 3 orders.

Explanation 3:

Now lets take bar which is showing 17 at the bottom of the image.

Assume that 100 Customers placed 17 Orders per each Customer. But non of them were not returned any Order.

Note: Please download the Data from below link to solve this challenge. If you use this data result should match with above image.

ClickHere to download Data

For more challenges: Click Here

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

Here I am coming with real time challenge. Those who are interested can try this and test your knowledge.

This is not expert level challenge. People are showing interest to solve these challenges. So I am just posting intermediate level challenge.

See below image:

In above chart I am showing % of unprofitable Customers in each State.

For example:

In “Illinois” State 57% of Customers has Profit less than zero.

Lets assume in “Illinois” State 100 Customers are there. In that 100 Customers, 57 Customers has Profit less than zero.

To Solve this challenge please download below workbook:

For more challenges: Click Here