Course: JustAcademy Tableau Training
Course Demo: Register for a Tableau Course Demo
A histogram is a data visualization used to understand the distribution of numerical data. It groups numeric values into intervals called bins and displays the number of records that fall within each interval. Each bar represents a range of values, and the height of the bar indicates the frequency or count of records in that range.
In Tableau, histograms help analysts understand where values are concentrated, whether a dataset is evenly distributed, whether it contains unusually high or low values, and whether the data has one or multiple peaks.
Example: A company wants to analyze the salaries of 500 employees. Instead of displaying every employee's salary individually, a histogram can group salaries into ranges such as ₹20,000–₹29,999, ₹30,000–₹39,999, ₹40,000–₹49,999, and so on. The bars show how many employees fall into each range.
| Term | Meaning | Example |
|---|---|---|
| Bin | An interval or range used to group numerical values. | ₹20,000–₹29,999 |
| Bin size | The width of each interval. | 10,000 salary units |
| Frequency | The number of observations that fall within a bin. | 45 employees in a salary range |
| Distribution | The way values are spread across the available ranges. | Most salaries fall between ₹30,000 and ₹50,000. |
| Outlier | A value that is unusually far from most other observations. | A salary much higher than the rest of the salaries |
| Continuous measure | A numerical field that can take values across a range. | Sales, profit, quantity, age or salary |
| Count | The number of records or values represented in a group. | Number of orders in each quantity bin |
A histogram converts a continuous numerical field into a set of ranges. Tableau assigns each record to the appropriate bin and calculates how many records belong to each range.
For a standard frequency histogram, the horizontal axis represents the numerical ranges and the vertical axis represents the number of records in each range.
| Order Quantity Range | Number of Orders |
|---|---|
| 1–2 items | 35 |
| 3–4 items | 60 |
| 5–6 items | 42 |
| 7–8 items | 25 |
| 9–10 items | 12 |
In this example, the 3–4 items range has the highest frequency, so it would have the tallest bar. The 9–10 items range has the lowest frequency, so it would have the shortest bar.
| Feature | Histogram | Bar Chart |
|---|---|---|
| Purpose | Shows the distribution of numerical data. | Compares values across categories. |
| Data type | Usually continuous numerical data grouped into bins. | Usually categorical data. |
| Horizontal axis | Numerical intervals or bins. | Categories such as regions or products. |
| Bar spacing | Bars generally touch because the intervals are continuous. | Bars are commonly separated by spaces. |
| Typical question | How are order quantities distributed? | Which region has the highest sales? |
| Example | Distribution of customer ages. | Sales by customer segment. |
Histograms are especially useful when the goal is to study one numerical variable's distribution. If the main goal is to compare categories, compare exact individual values, or show changes over time, another chart type may be more appropriate.
Tableau provides a convenient histogram chart type through the Show Me panel. This method is suitable for beginners and is usually the fastest way to create a basic histogram.
What Tableau does automatically: The selected numerical measure is grouped into bins. Tableau uses the bin field along the horizontal axis and places the count of the original measure on the vertical axis. The exact default bin size depends on the data and Tableau's bin-size calculation.
A histogram appears with numerical ranges along the horizontal axis and counts along the vertical axis. The tallest bar identifies the bin containing the greatest number of records.
Creating a histogram manually gives you greater control over the bin field and its size. This is useful when you want a specific interval width or need to understand how Tableau constructs the chart.
In the Data pane, find the numerical measure that you want to analyze. For example, select Sales, Profit or Quantity.
Tableau creates a new binned field, often named something like Sales (bin) or Quantity (bin). This field groups the numerical values into equal-sized intervals.
Drag the newly created bin field to the Columns shelf. If required, use the field's context menu to convert it to Continuous so that the horizontal axis displays the intervals on a continuous numerical scale.
Drag the original numerical measure—not the bin field—to the Rows shelf. Tableau may initially display an aggregation such as SUM. For a frequency histogram, change the aggregation to Count.
Bin size is the width of each numerical interval. Selecting an appropriate bin size is important because it changes the level of detail and can affect the patterns visible in a histogram.
Suppose customer purchase amounts range from ₹0 to ₹10,000.
| Bin Size | Possible Ranges | Typical Effect |
|---|---|---|
| ₹500 | ₹0–₹499, ₹500–₹999, and so on | More detailed distribution with more bars. |
| ₹1,000 | ₹0–₹999, ₹1,000–₹1,999, and so on | A moderate level of detail. |
| ₹2,500 | ₹0–₹2,499, ₹2,500–₹4,999, and so on | Fewer, broader groups. |
Important: Very small bins can make a chart noisy, while very large bins can hide meaningful patterns. Try several reasonable bin sizes and select one that supports the business question without obscuring the data.
In Tableau, a binned field can appear as a discrete or continuous field. A discrete field creates separate headers for distinct values or ranges, whereas a continuous field creates an axis. For a typical histogram, a continuous bin axis often provides a clear view of the numerical intervals.
If the axis does not look like a conventional histogram, right-click the bin pill and check whether the Continuous option is appropriate for your view.
Good formatting makes the histogram easier to understand and present to business users.
Use a descriptive title, such as Distribution of Order Quantities, Customer Salary Distribution, or Distribution of Order Sales.
Make the horizontal axis describe the measure ranges and the vertical axis describe the count or frequency. For example, use Order Quantity Range and Number of Orders.
Use a consistent color for a simple histogram. If you add a meaningful category to Color, ensure that the resulting colors help explain a comparison rather than merely decorating the chart.
Use suitable number formats for currency, percentages, or counts. For example, display salary ranges as currency when analyzing payroll data.
Customize tooltips to show useful information, such as the bin range and number of records. Avoid adding too many fields that distract from the primary interpretation.
The overall shape of a histogram can reveal useful information about the underlying data.
A normal-shaped distribution is approximately bell-shaped, with most observations near the center and fewer observations toward either end. Real business datasets do not always follow a normal distribution.
A right-skewed distribution has most observations concentrated toward the lower or middle ranges, with a longer tail extending toward higher values. Customer spending, income, and property prices can sometimes show this pattern.
A left-skewed distribution has many observations toward the higher ranges and a tail extending toward lower values. This can occur when most scores are high but a smaller number of low scores remain.
A bimodal distribution has two noticeable peaks. This may indicate that the dataset contains two different groups. For example, a salary dataset might contain separate groups of entry-level employees and senior employees.
A roughly uniform distribution has bars with similar heights across a range. The frequencies are approximately evenly distributed, although small differences may occur.
A small number of observations in extreme bins may indicate potential outliers. Investigate these records before deciding whether they are errors, unusual but valid observations, or evidence of a special business condition.
| Business Area | Numerical Field | Example Question |
|---|---|---|
| Sales | Order value | What order-value ranges occur most frequently? |
| Human Resources | Employee salary | How are salaries distributed across the organization? |
| Marketing | Customer spending | Which spending ranges contain the most customers? |
| Education | Exam score | How are students' scores distributed? |
| Manufacturing | Product measurement | Are product measurements concentrated near the target range? |
| Customer Support | Resolution time | How long do support cases usually take to resolve? |
| Finance | Transaction amount | Which transaction ranges are most common? |
| E-commerce | Delivery time | How frequently are deliveries completed within each time range? |
Business scenario: An online store wants to understand how its order sales are distributed. The analyst uses the Sales measure to determine whether most orders have low, medium, or high sales values.
| Order ID | Sales Amount |
|---|---|
| 1001 | ₹450 |
| 1002 | ₹800 |
| 1003 | ₹1,200 |
| 1004 | ₹1,750 |
| 1005 | ₹2,200 |
| 1006 | ₹2,650 |
| 1007 | ₹3,100 |
| 1008 | ₹3,800 |
| 1009 | ₹4,500 |
| 1010 | ₹7,200 |
The sample data above is illustrative. Actual findings must be based on the histogram created from the complete dataset.
A category can sometimes help explain why a distribution has a particular shape. For example, you may want to compare order quantities by customer segment.
Depending on the view and configuration, Tableau may show colored sections within the bars. When comparing proportions between bins, configure the appropriate percentage calculation and verify that it is computed within each bin rather than across the entire view.
Tip: Adding many categories can make the histogram difficult to read. If the comparison becomes crowded, create separate views or use a filter.
| Chart Type | Best Used For | Key Difference |
|---|---|---|
| Histogram | Showing how numerical values are distributed across ranges. | Shows frequency by bin. |
| Box Plot | Summarizing median, quartiles and spread; comparing distributions. | Emphasizes summary statistics and potential outliers. |
| Bar Chart | Comparing values across named categories. | Compares categories rather than continuous intervals. |
| Scatter Plot | Exploring the relationship between two numerical variables. | Shows paired values rather than frequency within one variable. |
| Line Chart | Showing change over time or across an ordered sequence. | Emphasizes trends and continuity over time. |
| Problem | Possible Cause | Solution |
|---|---|---|
| Histogram option is unavailable in Show Me. | The view may not have the required single numerical measure selected, or other fields may be present. | Start with a clean worksheet and select one suitable measure. |
| Bars show totals instead of record counts. | The original measure is aggregated as SUM. | Change the aggregation to Count for a frequency histogram. |
| Too many bars appear. | The bin size may be too small. | Increase the bin size and compare the resulting distribution. |
| Too few bars appear. | The bin size may be too large. | Reduce the bin size to reveal more detail. |
| The horizontal axis is difficult to read. | The bin field may be discrete or the labels may be unclear. | Review the continuous-axis setting and improve the labels. |
| The distribution looks unexpected. | Data quality issues, extreme values, filters, or the bin size may affect the chart. | Inspect the source data, filters, and bin settings. |
| Null values are not represented as expected. | Some records may not have a usable value for the selected measure. | Inspect null values and decide how they should be handled. |
| Category colors make the chart confusing. | Too many categories may be displayed together. | Use a filter, simplify the color encoding, or split the comparison into separate charts. |
Create a histogram using the Quantity field from Sample - Superstore. Identify the bin containing the most records and test a different bin size.
Create a histogram using Sales. Experiment with multiple bin sizes and describe how the distribution changes.
Create a histogram using Profit. Investigate whether values appear concentrated near zero and whether any bins contain unusually high or low profits.
Build a histogram of order quantity and add Segment to Color. Explain whether the segments appear to contribute differently across the bins.
Using a suitable employee dataset, create a salary histogram. Select meaningful salary intervals and summarize where most employees fall.
Objective: Build a Tableau dashboard that helps business users understand the distribution of order sales and quantities.
Answer: A histogram is a chart that displays the distribution of numerical data by grouping values into intervals called bins and showing the frequency of records in each interval.
Answer: A bin is a numerical interval that groups values within a specified range. Tableau can create a binned field from a suitable numerical measure.
Answer: Bin size is the width of each interval. It determines how finely the data is grouped.
Answer: You can select a numerical measure and use the Histogram option in Show Me, or manually create bins, place the bin field on Columns, and place the count of the original measure on Rows.
Answer: A histogram displays the distribution of numerical values grouped into ranges, while a bar chart compares separate categories.
Answer: Count measures how many records fall into each bin, which is the usual goal of a frequency histogram.
Answer: Smaller bins create more detailed intervals and usually produce more bars. They may reveal detail but can also make the chart noisy.
Answer: Larger bins combine more values into each interval, producing fewer bars and a more summarized view of the distribution.
Answer: It is a distribution with a longer tail toward higher values, while many observations are concentrated in lower or middle ranges.
Answer: It is a distribution with two prominent peaks, which may indicate two groups or patterns in the dataset.
Answer: Yes. A category can be placed on Color to examine how groups contribute to the bins. The result should remain readable and should be interpreted carefully.
Answer: Avoid using it when the primary objective is to compare named categories, show a trend over time, or examine the relationship between two numerical variables. A bar, line, or scatter plot may be more appropriate.
Histograms are valuable Tableau visualizations for understanding how numerical values are distributed. By creating bins, counting records, and choosing a suitable bin size, analysts can identify common ranges, compare distributions, and investigate possible outliers. A well-designed histogram helps transform raw numerical data into a clear view of business patterns.
To continue learning Tableau, explore the JustAcademy Tableau Training course or Register for a Tableau Course Demo.
