Specialist
Data Analyst

2.3. Create custom table calculations

Leave a Comment / By LearningTableau / November 8, 2024

Use the Data Analyst resource guide to find documentation related to this topic. More data analyst practice questions here.

Which of the following best describes a situation where you would use a custom table calculation instead of a Quick Table Calculation?

You want to display each value as a percentage of the total for a single dimension, such as "Percent of Total."

You need to perform a moving average on the data to smooth out daily fluctuations.

You want to create a table calculation that requires more control over specific dimensions, such as computing a difference across non-standard partitions.

You want to add a calculated field to perform a basic sum or average across the data.

None

Which of the following methods is appropriate for creating a Year-to-Date (YTD) calculation that dynamically updates based on the current date?

Manually filtering the dataset to include only dates from the start of the year to today's date.

Using a calculated field with the formula: IF [Order Date] <= TODAY() AND DATETRUNC('year', [Order Date]) = DATETRUNC('year', TODAY()) THEN [Sales] END.

Applying a Quick Table Calculation for Running Total on the Sales measure.

Creating a parameter to select the desired date range for the YTD calculation.

None

Time's up

Time is Up!

Post navigation

2.2. Create quick table calculations

2.4. Create and use filters

Leave a Reply Cancel reply