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

To add two sheets to the dashboard that support the Show/Hide button, you can add them to either a horizontal or a vertical container. A container is an object that can hold one or more sheets or other objects and allow you to arrange them in a layout. A Show/Hide button is a feature that lets you hide or show a container and its contents on the dashboard. You can add a Show/Hide button to any container, whether it is tiled or floating, by using the drop-down menu of the container and selecting “Add Show/Hide Button.” You can also customize the appearance and behavior of the button.

To add a horizontal or a vertical container to the dashboard, you can drag them from the Objects pane to the dashboard. A horizontal container will arrange the sheets or objects horizontally, while a vertical container will arrange them vertically. You can then drag the sheets you want to add from the Sheets pane to the container. You can resize and reorder the sheets or objects within the container by using the handles and arrows.

The other objects in the Answer Area, such as text, image, web page, blank, navigation, download, and extension, do not support the Show/Hide button. They are either static elements that cannot hold other objects, or dynamic elements that require user interaction or external sources. You can add them to the dashboard as well, but they will not have the same functionality as a container with a Show/Hide button.

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

A reference line is used in Tableau to display a line at a constant value or a computed value such as an average, median, minimum, or maximum in a bar chart. In this case, adding a reference line would allow you to show the median, upper quartile, and lower quartile, which corresponds to the changes shown in the bar chart.