In this series of Tableau Certification Questions for Tableau Desktop Certification exams, we will discuss Calculations in Tableau. The purpose of this Tableau Exam Questions part-5 is to explore Tableau Calculations targeting the Tableau Desktop Specialist or Certified/Qualified Associate exams. We have provided a complete step by step solution for each exam question at the end with the correct answer. Check out our detailed Tableau Certification Preparation Training Videos from Tableau Certified Professionals to explore further questions and tips for passing the exam on the first attempt.
Let’s dive into Tableau Certification Questions related to Tableau Calculations in Tableau.
What is the movie name that starts with the letter ‘T’ and when sorted on the sum of profitability in descending order comes in fourth place.
Note: Use Hollywood’s Most Profitable Stories Sample Data
Correct Answer: D
Checkout Solution:
1. Create a calculation field first letter.
2. Put sum of profitability to Columns and Film on Rows.
3. Put the calculated field ‘first letter’ in filter shelf and select ‘T’.
4. It will look like this below:
From here you can identify that fourth record is Twilight: Breaking Down
Using Orders sheet is Sample-Superstore , Find out what is percentage of sales for customer segment ‘Corporate’ in year 2012 where product category is Furniture.
Note: Use Superstore Sample Data
Choose the correct option:
Correct Answer: A
Check out the Solution:
1. Put customer segment on rows shelf.
2. Put Product Category on Filter and select ‘Furniture’ as shown below:
3. Put Order Date on Filter and select 2012.
4. Now Put Sales on Text in the Marks Card.
5. Now select Sales in the Marks Card, Right Click and select the Option ‘Percentage of Total’.
6. It shows that Percentage of customer segment ‘Corporate’ for selected parameters in 38.20 %.
Using Orders Sheet in Sample Super Store, Find the total sales of orders that took 3 days for ‘Express Air’ shipping mode.
Note: Use Superstore Sample Data
Correct Answer: A
Checkout the Solution:
1. Create Calculated Field as:
2. Convert it to Dimension.
3. Put Dimension ‘Delivery Days’ on Filter and select 3.
4. Put Shipping Mode in Filter and select the option.
5. Now Put Sales on Text in the Marks Card.
It will show the Sales Value 37458.
Stay in touch for the next part in this series for Tableau Certification questions related to Mapping.
Related Articles:
Choosing the right career path can be a daunting task, especially with the myriad of…
Believe it or not, the concept of human resources has existed for more than 100…
Web3 managed to change the gaming industry by leveraging blockchain technology. It offers a decentralized…
College is often fun and is filled with lots of activities, especially in the first…
The internet has evolved significantly, from static Web1 pages to the dynamic, user-driven Web2 we…
Disaster recovery (DR) is the process which an organization can recover and keep working after…