5. What function could be used to assign consecutive values (1, 2, 3, …) to the customer names based on the profit of each customer, with lower values assigned to customers with higher profit?
It is stated that correct answer is the 2nd one. But how is lower values assigned to customers with higher profit with ‘Desc’ attribute in the formula?
Lower values assigned to the customers with higher profit means that rank 1 will be assigned to the customer with the highest profit, rank 2 to the with the second highest profit and so on. This is why we have the ‘desc’ parameter so we can start with the highest profit and have the lowest profit the last one in the list.
Because when you use desc, it sorts the rows in descending order.
So the customers with highest profit appears first with “lowest” Rank which would be 1.
By default asc is the sort type and hence 1 will be assigned to least profit value. so if we want 1 to be assigned to high profit value, desc should be used
Option a) is correct since we want to filter only the worksheets that use the current data source, not all worksheets that use related data sources as well.
1st question seems wrong, from string to date function we use DatePharse. syntax : DATEPARSE(date_format, date_string),
examaple: DATEPARSE(‘yyyy-MM-dd’, “1986-03-25”) = #March 25, 1986#
DATEPARSE can be used as well to convert the string to a date, but it is not one of the available options. DATE does the same thing and is the correct option.
Hope this helps.
Immediately showed me holes in my base knowledge.
Glad it was helpful!
ok
5. What function could be used to assign consecutive values (1, 2, 3, …) to the customer names based on the profit of each customer, with lower values assigned to customers with higher profit?
RANK (sum([Profit]),’desc’)
RANK _UNIQUE(sum([Profit]),’desc’)
RANK _MODIFIED(sum([Profit]),’asc’)
RANK (sum([Profit]), ‘asc’)
It is stated that correct answer is the 2nd one. But how is lower values assigned to customers with higher profit with ‘Desc’ attribute in the formula?
Hello,
Lower values assigned to the customers with higher profit means that rank 1 will be assigned to the customer with the highest profit, rank 2 to the with the second highest profit and so on. This is why we have the ‘desc’ parameter so we can start with the highest profit and have the lowest profit the last one in the list.
Hope this makes it clearer.
Narcis
Lower values of the rank to customers with high profit so yes you need to sort descending for that
Because when you use desc, it sorts the rows in descending order.
So the customers with highest profit appears first with “lowest” Rank which would be 1.
By default asc is the sort type and hence 1 will be assigned to least profit value. so if we want 1 to be assigned to high profit value, desc should be used
Number 6 is not correct. On the Filters shelf, right-click the field and select Apply to Worksheets > All Using Related Data Sources.
Hi Tammie,
Option a) is correct since we want to filter only the worksheets that use the current data source, not all worksheets that use related data sources as well.
Hope this makes it clearer.
Narcis
Number 4 does not offer correct answers, the correct answer is “Inner, Left, Right, Full Outer” (and Join if you want)
Hi Kay,
The correct answer is c) Left join, Inner join, Right join, leftOnly join, rightOnly join, notInner join, Full.
You can find more info here – https://help.tableau.com/current/prep/en-us/prep_combine.htm
Hope this makes it clear,
Narcis
1st question seems wrong, from string to date function we use DatePharse. syntax : DATEPARSE(date_format, date_string),
examaple: DATEPARSE(‘yyyy-MM-dd’, “1986-03-25”) = #March 25, 1986#
Hi,
DATEPARSE can be used as well to convert the string to a date, but it is not one of the available options. DATE does the same thing and is the correct option.
Hope this helps.