# Quick table calculations, bins and histograms

*Tableau Desktop Foundations Study Guide · Exploring and Analyzing Data · Last updated October 29, 2026 · https://www.certifyforce.com/study-guide/tableau-desktop-foundations/exploring-and-analyzing-data/quick-table-calculations-bins-and-histograms*

Apply a quick table calculation to a measure in the view (Running Total, Rank, Percent of Total, Year over Year Growth and the rest), recognize the delta symbol, adjust it with Edit Table Calculation, and build histograms from bins: Create > Bins, Size of bins, Show Me and continuous bins.

- Certification: Salesforce Tableau Desktop Foundations
- Exam section: Exploring and Analyzing Data
- Study guide: https://www.certifyforce.com/study-guide/tableau-desktop-foundations

**Official exam objective:**

> Apply analytics to a worksheet: Add a manual or a computed sort; Add a reference line; Use a quick table calculation; Use bins and histograms; Create a calculated field (for example, string, date, simple arithmetic); Explain when to use a parameter; Display totals on a worksheet.

## What the exam expects

- Apply a quick table calculation to a measure in the view and pick the type that matches a requirement, such as growth over the previous year or a rank.
- Recognize an applied table calculation by its delta symbol and change it with Edit Table Calculation (type, aggregation, Compute Using).
- Copy a measure with Ctrl-drag so the original encoding stays and the copy carries the table calculation.
- Create bins from a measure, change the Size of bins, and build a histogram with Show Me or by hand.
- Turn a discrete bin into a continuous axis.

Key terms:
- **Table calculation:** a transformation applied to the values in a visualization, computed on the local data in the view.
- **Quick table calculation:** a common table calculation applied in one click with the most typical settings.
- **Bin:** an equal-sized container for a range of values, stored as a new dimension created from a measure.
- **Histogram:** a chart that groups a continuous measure's values into bins and shows the shape of the distribution.

## Key facts

| Fact | Detail | Source |
|---|---|---|
| Quick table calculation scope | Only on measures in the view | [Quick Table Calculations](https://help.tableau.com/current/pro/desktop/en-us/calculations_tablecalculations_quick.htm) |
| Applied indicator | A delta symbol appears on the field | [Quick Table Calculations](https://help.tableau.com/current/pro/desktop/en-us/calculations_tablecalculations_quick.htm) |
| Edit Table Calculation | Type, aggregation, how to compute | [Quick Table Calculations](https://help.tableau.com/current/pro/desktop/en-us/calculations_tablecalculations_quick.htm) |
| What a table calculation uses | Local data in the view; filtered-out data is ignored | [Transform Values with Table Calculations](https://help.tableau.com/current/pro/desktop/en-us/calculations_tablecalculations.htm) |
| Rank default order | Descending: most to least | [Table Calculation Types](https://help.tableau.com/current/pro/desktop/en-us/calculations_tablecalculations_definebasic_runningtotal.htm) |
| Ctrl-drag | Copies a field without removing it from the original location | [Build a Histogram](https://help.tableau.com/current/pro/desktop/en-us/buildexamples_histogram.htm) |
| Create bins | Data pane: right-click a measure, Create > Bins | [Create Bins from a Continuous Measure](https://help.tableau.com/current/pro/desktop/en-us/calculations_bins.htm) |
| Bins from a measure | A new dimension; can be converted to continuous | [Create Bins from a Continuous Measure](https://help.tableau.com/current/pro/desktop/en-us/calculations_bins.htm) |
| Size of bins fallback | Defaults to 10 when Tableau can't optimize quickly | [Create Bins from a Continuous Measure](https://help.tableau.com/current/pro/desktop/en-us/calculations_bins.htm) |
| Change bin size | Right-click the bin in the Data pane, Edit | [Build a Histogram](https://help.tableau.com/current/pro/desktop/en-us/buildexamples_histogram.htm) |
| Show Me histogram | Available with a single measure and no dimensions | [Build a Histogram](https://help.tableau.com/current/pro/desktop/en-us/buildexamples_histogram.htm) |

## Check yourself

- Why doesn't a table calculation account for rows removed by a filter?
- When is the histogram offered in Show Me?
- What value labels each bin?
- What does Ctrl do while you drag a field to another shelf?

## Sources

- [Quick Table Calculations](https://help.tableau.com/current/pro/desktop/en-us/calculations_tablecalculations_quick.htm)
- [Table Calculation Types](https://help.tableau.com/current/pro/desktop/en-us/calculations_tablecalculations_definebasic_runningtotal.htm)
- [Transform Values with Table Calculations](https://help.tableau.com/current/pro/desktop/en-us/calculations_tablecalculations.htm)
- [Build a Histogram](https://help.tableau.com/current/pro/desktop/en-us/buildexamples_histogram.htm)
- [Create Bins from a Continuous Measure](https://help.tableau.com/current/pro/desktop/en-us/calculations_bins.htm)

## About the full unit

The "Core concepts", "Exam traps" and "Worked scenario" sections of this unit, its 5 linked practice questions, and unlimited timed mock exams are included with the Tableau Desktop Foundations pack (USD $19): https://www.certifyforce.com/practice-exams