Histogram

A histogram chart is a chart that displays the shape of the distribution.

A histogram looks like a bar chart but group values for a continuous measure into range. In the histogram, each bar represents the height of the number of values present in that range.

To create a histogram, we need only one measure. It creates the additional bin field for the measure.

For example, consider the data source such as Sample-Superstore, and if you to find the Quantities of sales for different Segment. For this, follow the below procedure step by step, such as:

Step 1: Go to the worksheet.

Step 2: Drag the measure Quantity into the columns shelf.

Histogram

Step 3: Click on the "show me" toolbar and select the histogram chart icon, shown in the below screenshot.

Histogram

NOTE: The histogram chart is available in "show me" when the view contains only one measure and no dimensions.

Step 4: After selecting the histogram chart as the chart type. Then,

  • The view changes and shows vertical bars, with a continuous X-axis and Y-axis.
  • The measure Quantity with SUM aggregate in columns shelf is replaced by continuous Quantity(bin) dimension.
  • The Quantity field moves to the rows shelf and aggregation changes from SUM to CNT or (Count).
Histogram

Step 5: Drag the dimension Segment and drop into the Color shelf under the Marks pane.

Histogram

After adding the Segment field to Color shelf, you can see a relationship between the Segment field and the Quantity of item as per order is shown in the below screenshot.

Histogram

Step 6: Hold the Ctrl key in the keyboard and drag CNT(Quantity) field from the rows shelf Label shelf under the Marks pane.

Histogram

Step 7: Right-click on the CNT(Quantity) field in Marks pane. And

  • Click on the Quick Table Calculation option from the list.
  • Select the Percent of Total option.
Histogram

Now each colored section of each bar shows its percentage of total quantity shown in the following screenshot.

Histogram




Latest Courses