Tableau Desktop Specialist — Question 121

Which function should a Data Analyst use to average sales at a less-granular level of detail than is in the view?

Answer options

• A. EXCLUDE
• B. RUNNING_AVG
• C. INCLUDE
• D. AVG

Correct answer: A

Explanation

The EXCLUDE function allows a Data Analyst to average sales while ignoring certain dimensions, thus providing a less detailed view. RUNNING_AVG calculates a moving average, INCLUDE adds more dimensions which does not fit the requirement, and AVG simply computes the average without adjusting the granularity.