Analytics-DA-201 Exam Dumps - Salesforce Certified Tableau Data Analyst

Set actions allow selections made in a worksheet or dashboard to update membership in an existing set. That set can then be used in calculations or placed on the Marks card to change how another visualization is encoded. A common design is to place set membership on Color, so selecting marks in a source view changes which marks are in or out of the set and therefore changes their colors in a target view. This is exactly the interaction described in option B. Set actions are not intended to join or filter across unrelated data sources automatically, and pie-chart dataset-size comparison is simply a chart-design task. Likewise, highlighting proportions in a Gantt chart is not a defining set-action behavior. The key mechanism is selection-driven set membership that controls a visual property such as Color.

A correct year-to-date filter must satisfy two requirements: the event must belong to the current calendar year, and its date must not be later than today. DATETRUNC( " year " , [Event Date]) = DATETRUNC( " year " , TODAY()) confirms that the event and today’s date fall within the same year. [Event Date] < = TODAY() then excludes future dates within that year. Option C identifies the current year but would also include future-dated events. Option D does the opposite by explicitly selecting dates after today. Option B compares each event date with the first day of its own year and therefore does not implement YTD filtering. Tableau documents DATETRUNC as truncating a date to a specified date-part level and TODAY() as returning the current date.

To combine the tables and meet the requirements, you should use a left join. A left join will keep all the records from the left table (Employeelnfo) and match them with the records from the right table (DepartmentInfo) based on the common field (Department ID). If there is no matching record in the right table, the fields from the right table will be null. This way, you will retain all the records from Employeelnfo, and also include the Department Name, Size, and VP fields from DepartmentInfo. Every record will have a full name because it is a field from the left table. A left join will look like this:

There are different ways to create a table calculation that shows sales growth over each year, but one possible answer is:

SUM([Sales])

LOOKUP(SUM([Sales]), -1)

PREVIOUS_VALUE(0)

 To calculate the sales growth over each year, you need to compare the current year’s sales with the previous year’s sales and divide the difference by the previous year’s sales. You can use the SUM, LOOKUP, and PREVIOUS_VALUE functions to achieve this. The SUM function returns the total sales for each year. The LOOKUP function returns the value of an expression in a target row, specified as a relative offset from the current row. The PREVIOUS_VALUE function returns the value of the expression in the previous row, or a specified value if there is no previous row. The formula for the table calculation is:

(SUM([Sales]) - LOOKUP(SUM([Sales] ), -1)) / PREVIOUS_VALUE(0)

This formula subtracts the sales of the previous year (LOOKUP(SUM([Sales]), -1)) from the sales of the current year (SUM([Sales] )) and divides the result by the sales of the previous year. If there is no previous year, the formula uses 0 as the denominator (PREVIOUS_VALUE(0)) to avoid division by zero errors.

Extensions in Tableau are web-based programs that can interact with dashboards. To add a button that allows users to export the dashboard as an image, you would use an Extension object. This could be a custom extension designed to trigger the download of the dashboard view as an image.

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

This formula uses a parameter (Pick Measure) to switch between the Sales and Profit measures. When the user selects ' 1 ' , it shows Sales, and when ' 2 ' is selected, it shows Profit. This dynamic switching is enabled by the Case function.