Free Practice Questions for Salesforce Analytics-DA-201 Exam

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 show the corresponding region when users hover their mouse over any of the bars, you need to drag Region to Tooltip on the Marks card. This will add Region as a field in the tooltip text that appears when users hover over a mark. You can also customize the tooltip text by editing it in the Tooltip dialog box. References: https://help.tableau.com/current/pro/desktop/en- us/buildmanual_shelves.htm https://help.tableau.com/current/pro/desktop/en-us/formatting_tooltips.htm

To show additional information such as the corresponding region when hovering over a bar in Tableau, you can drag the ' Region ' field to the ' Tooltip ' shelf on the ' Marks ' card. This will ensure that when a user hovers over a bar representing a city, the tooltip will dynamically display the region associated with that city.

we need to create a calculated field that displays the count of returns only for the first year in the table. To do this, we can use the following formula:

IF FIRST () = 0 THEN COUNT (Returns) END

This formula uses the FIRST () function, which returns the number of rows from the current row to the first row in the partition. If the current row is the first row, then FIRST () returns 0. The IF statement checks if this condition is true, and if so, it returns the count of returns for that row. Otherwise, it returns NULL.

To complete the formula in the calculated field, you should select the following options from the drop-down menus:

FIRST ()

0

COUNT (Returns)

https://help.tableau.com/current/pro/desktop/en-us/functions_functions_date.htm

In Tableau, to replace a sheet on a dashboard, you can simply drag the desired sheet (Sheet2 in this case) from the sheets list onto the dashboard where the current sheet (Sheet3) is. This will replace the existing visualization with the new one.

A Parameter action is designed to let users change a parameter value through direct interaction with a visualization. The parameter can then drive a calculated field that determines which measure—such as Sales, Profit, Quantity, or another metric—is displayed on the chart. Tableau ' s current action framework explicitly includes Change Parameter as an action type and notes that parameter actions can be used with calculations to customize how data is displayed. A Set action changes membership in a set, a Highlight action emphasizes selected marks without changing the metric being displayed, and a Filter action restricts the data shown in the target view. Because the requirement is to let the user dynamically select the measure displayed rather than filter or highlight records, the appropriate action type is Parameter .

To change the story point format to show the current story point number out of the total number of story points, you should use the Numbers option in the Layout tab. This option will display the story points as numbers in a horizontal or vertical sequence, such as 1/2, 2/2. You can also choose to show or hide the next and previous arrows for navigation. The Numbers option will help you indicate the progress and order of your story points more clearly than the other options. References:

Creating a Story - Tableau

New in 9.0: Formatting the Story Points Navigator - Tableau

Tableau Certified Data Analyst Study Guide

To add a column that shows the day of the week for each row, you should complete the formula as follows:

DATENAME

(

‘weekday’

, [Order Date])

 The DATENAME function in Tableau returns the name of a specified part of a date or datetime value, such as the year, month, or day. It takes two arguments: the date part and the date. In this question, you want to return the name of the weekday, such as Monday, Tuesday, or Wednesday, for each order date. Therefore, you need to use ‘weekday’ as the date part and [Order Date] as the date. The formula will return a string value that represents the name of the weekday for each order date.