TDA-C01 Exam Dumps - Tableau Certified Data Analyst Exam

To add a comment to March 2020 on a line chart, you need to annotate that mark. You can right-click on the mark and select Annotate > Mark from the menu. This will open a dialog box where you can type your comment and format it as you like. You can also drag and drop the annotation to position it on the worksheet. Dragging the growth rate to Text on the Marks card will add a label to every mark on the line chart, enabling captions will show a description of the worksheet at the bottom, and adding a tooltip will show a text box when users hover over a mark. References: https://help.tableau.com/current/pro/desktop/en-us/formatting_annotations.htm https://help.tableau.com/current/pro/desktop/en-us/formatting_annotations_create.htm

To add a comment to a specific point on a line chart, such as March 2020 in the provided visualization, you would use the 'Annotate' feature. Right-clicking on the data point for March 2020 and selecting 'Annotate' allows you to add a text annotation directly to the chart, which can be used to highlight and comment on that particular data point.

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.

To create the dashboard as shown in the image, you need to use a vertical layout container that will adjust the height of the sheets according to the window size. You also need to set the Fit to Entire view option for both sheets so that they will resize proportionally when you click a category on the top sheet. This way, you can achieve the desired effect of having the bottom sheet expand to fill the space left by the top sheet when it filters out some categories. References:

Size and Lay Out Your Dashboard - Tableau

Create a Dashboard - Tableau

Format Dashboard Layout in Tableau - GeeksforGeeks