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?