Have you gotten the error “All fields must be aggregate or constant when using table calculation functions or fields from multiple data sources” in Tableau?

# Using Symbols to Get More out of Your Tableau Highlight Tables

# Create a Percent of Total in Tableau That Isn't Affected by Filters

As you likely know from using Table Calculations in Tableau, they only compute against the marks displayed in a worksheet. Check out **this webinar** in you need a refresher.

That means when a filter is applied to the worksheet, a table calculation will update to reflect only the data present in the worksheet.

# How do Tableau Table Calculations Work?

# Tableau Table Calculations - What Does “Specific Dimensions” Mean?

# Highlighting Points in a Line Graph

# Calculating Difference from Average in Tableau

I shared an example with a class recently about how to use Table Calculations in Tableau and got a request to share this via a write-up. One of the most powerful things about Table Calculations in Tableau is the ability to set a scope and direction.

# Comparing Year Over Year in Tableau

When calculating growth rates from one date period to another, it’s important to compare apples to apples. For instance, when building a graph in Tableau to compare quarterly sunscreen sales in Seattle, I probably wouldn’t want to compare Q3 Sales (July - September) to Q2 Sales (April - June) because there will be more sales in Q3. The product has a cyclical sales cycle. Instead, I would rather compare Q3 Sales of this year to Q3 Sales of last year to more accurately understand growth rates.