steps to making a histogram first make a table

Check out other properties associated with Histogram Charts.This type of axis is not possible out-of-box in charts like pie-charts and hence charts such as histogram charts are preferred. This chart shows 4 employees in the 20 - 25 group, 5 employees in the 25 - 30 group and 6 employees in the 30 - 35 group.Īlso note that the 'Percentage of Total' axis is generated and calculated automatically without any programming efforts and this axis is very useful in statistical analysis. Execute the report and the report should look like the below screenshot. Change this value to '5', so that the age group we have is divided into 3 categories as desired.

In the CustomAttribute category, you will find a property 'HistogramSegmentIntervalWidth' and the default value is zero. Let's say we want to see the data in three age groups 20 - 25, 25 - 30 and 30 - 35 and the number of employees in each age group. This is a histogram chart, but the problem with this chart is that by default the chart has selected all fifteen distributions, so you get one employee for each age category which is not very helpful. In the CustomAttribute category, select 'ShowColumnAs' property and set the value as 'Histogram' as shown in the below screenshot.Įxecute the report and you should find results similar to the below screenshot. Select the EmpAge chart series and open the properties window. In the next few steps we will see how a histogram chart can be a much simpler approach. A typical approach to solve this issue would be to retrieve the count of employees falling into a few predefined age categories and show it in a distribution chart like a pie-chart.

In reality, an employee table can contain records for hundreds to thousands of employees and therefore if the requirement is to analyze age distribution this type of report won't serve the purpose. Add a bar chart to the report and configure it as shown in the below screenshot.Įxecute/Preview this report and your report should look like the below screenshot and you will see data listed for all fifteen employees.

Let's create a sample table called Employee that has columns EmpID and EmpAge with the data as shown in the below screenshot.Ĭreate a new SSRS report and configure it to use the data from the table we just created. SolutionIn this tip we will create a histogram chart in SSRS to show how to aggregate data will very little effort.

Steps to making a histogram first make a table