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

**R****egion**wise**P****rofit**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

**C****ustomers**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?**