Using Calculations: Working with Aggregations

Question 1

When aggregating data, especially in calculations with multiple fields, pay special attention to ______, especially when the view contains ______

Answer 1

the order of operation; totals

Question 2

How does Tableau treat calculated fields that already aggregate data?

Answer 2

It will not aggregate them any further than what is defined in the calculation

Question 3

If you create a calculated field with the formula [Profit]/[Sales], what will the field look like when you add it to the view?

Answer 3

SUM(Profit/Sales)

Question 4

When calculated fields are created based on measures, what are your two options for where to apply aggregation?

Answer 4

You can include the aggregation within the calculation or apply it in when the calculated field is used in the view

Question 5

When the aggregation is applied as you add a field to the view, at what level is the data aggregated?

Answer 5

Row level - it is applied to every row of your data

Question 6

When the aggregation is done within the calculation of the field, at what level is the data aggregated?

Answer 6

Whatever levels you have brought into the view

Question 7

How does Tableau indicate that a field’s aggregation was done within the calculation and not at the row level?

Answer 7

The field name is enclosed in AGG() when it is brought into the view