Salesforce Updated Analytics-DA-201 Exam Questions and Answers by marlo

The chart is partitioned into separate panes by year, and each pane contains its own horizontal reference line based on the values within that pane. Therefore, the reference-line Scope must be set to Pane , which instructs Tableau to calculate and draw a separate line for each pane rather than a single line across the entire table. The line also represents a computed mean rather than a fixed numeric threshold, so the aggregation must be Average . Tableau ' s official documentation states that Table, Pane, and Cell determine the scope of a reference line, while Average places the line at the average value along the applicable axis. A Table-scoped average would produce one overall line, and a Constant would use a manually specified value rather than recalculating per pane.

To get the number of different types of awards that have been won, you should use the formula COUNTD({Award}). This formula will return the count of distinct values in the Award field, which are the different types of awards that have been won.

The other options are not correct for this scenario. COVAR({Award}) is not a valid function in Tableau. MAX({Award}) will return the maximum value in the Award field, which may not be a type of award. INDEX() will return the index or rank of each row in a partition, which is not related to the types of awards. References: https://help.tableau.com/current/pro/desktop/en-us/functions_functions_aggregate.htm#COUNTD https://help.tableau.com/current/pro/desktop/en-us/functions_functions_tablecalculation.htm#INDEX

The COUNTD function in Tableau calculates the number of distinct (unique) items in a field. When looking to get the number of different types of awards that have been won, the COUNTD([Award]) function will count each unique award name only once, regardless of how many times it appears in the dataset. This will return the total number of unique award types.