Pass the Salesforce Tableau Data Analyst Analytics-DA-201 Questions and answers with Dumpstech

To combine the lines to appear as shown in the second chart, you should set Discount to Dual Axis. Dual Axis is a feature that allows you to show two measures on two separate axes on one chart. You can create a dual axis by right-clicking on a measure on any shelf and selecting Dual Axis from the menu. This will create two axes on one chart and synchronize their scales.

In this case, you want to show Profit and Discount on two separate axes on one chart. You can right-click on Discount on any shelf and select Dual Axis from the menu. This will create a dual axis chart that shows Profit and Discount as two lines with different colors.

The other options are not correct for this scenario. Dragging Discount to Color on the Marks card will change the color of Profit based on Discount, but it will not show two lines. Converting Discount to Discrete will change Discount from a green pill to a blue pill, but it will not affect how it appears on the chart. Dragging Discount to Columns shelf will create two separate charts for Profit and Discount, but it will not combine them. References: https://help.tableau.com/current/pro/desktop/en-us/multiplemeasures.htm https://help.tableau.com/current/pro/desktop/en-us/multiplemeasures_dualaxes.htm

The LOOKUP function is used to return the value of a specified field in a different row, which can be defined relative to the current row. In this context, it can be used to in clude a number with the position of each state within each region by looking up the SUM([Quantity]) in each respective position.  References:  The information is inferred from general Tableau knowledge as well as the following sources:

Tableau Functions (Alphabetical)

LOOKUP

Tableau Certified Data Analyst Exam Guide

Parameter actions allow a user to change a parameter value by directly interacting with marks in a visualization, such as by selecting or hovering over a mark. When that parameter is referenced by a calculated field, changing the parameter immediately changes the calculation ' s result and therefore the information displayed in the visualization. This enables highly interactive experiences without requiring the user to manipulate a separate parameter control. Tableau also supports parameter actions with reference lines, filters, and SQL queries. The action does not literally convert a parameter into a filter, nor does it create a static view or restrict interaction to predefined filters. Therefore, D best represents the advantage tested here: selections in the visualization can dynamically update parameter-driven calculations and consequently change the displayed analysis.

To analyze the average revenue per product in different regions over time, you need to use two fields that contain numeric, quantitative values that you can measure and aggregate. Quantity and Revenue are both measures that fit this criterion. You can multiply Quantity and Revenue to get the total sales for each product, and then divide by the number of products to get the average revenue. You can also use these measures to create charts and tables that show the trends and comparisons over time and across regions. References:

Dimensions and Measures, Blue and Green - Tableau

Tableau Certified Data Analyst Study Guide