Bar Chart Report

A bar chart report is widely used for data visualization. Four types of bar charts can be created using the designer interface - simple bar chart, stacked bar chart, multi-series bar chart and multi-axis bar chart. This article explains how to create the different types of bar chart and provides a few examples.

Steps to Create Bar Charts

 

  1. Click New report > Custom Report to open the Report Designer interface

  2. Select page Type as Chart. Bar is selected as the default option

  3. Simple Bar Chart - one Dimension field for the X-axis and one Measure field for the Y-axis, optional Dimension fields for filters

    1. Add the Dimension fields from the left panel by clicking the drop-down sign next to the field name and selecting the appropriate destination (X-axis or Optional Filters)

    2. Add the Measure field from the left panel by clicking the '+' sign next to the field name. It will get added to Y-axis automatically

      ART_Bar_Chart.jpg

  4.  Stacked Bar Chart - one dimension field for the X-axis, one Measure field for the Y-axis and one Dimension field for 'Segment By', optional Dimension fields for filters

    1. Add the Dimension fields from the left panel by clicking the drop-down sign next to the field name and selecting the appropriate destination (X-axis, ‘Segment By’ or Optional Filters)

    2. Add the Measure field from the left panel by clicking the '+' sign next to the field name. It will get added to Y-axis automatically

      ART_Barchart_1.jpg

  5. Multi-Series Bar Chart - one Dimension field for the X-axis and more than one Measure fields for the Y-axis, optional Dimension fields for filters

    1. Add the Dimension fields from the left panel by clicking the drop-down sign next to the field name and selecting the appropriate destination (X-axis, ‘Segment By’ or Optional Filters)

    2. Add more than one Measure field from the left panel by clicking the '+' sign next to the field name. It will get added to Y-axis automatically

  6. Multi-Axis Bar Chart - one Dimension field for the X-axis of each added axes, one Measure field for the Y-axis of each added axes, optional Dimension fields for filters of each added axes. Adding multiple axes is most useful if all the X-axis fields are either ‘dates’ or if they represent the same field. Each axis can also have it own filter criteria

    1. Add the Dimension fields from the left panel by clicking the drop-down sign next to the field name and selecting the appropriate destination (X-axis, ‘Segment By’ or Optional Filters)

    2. Add more than one Measure field from the left panel by clicking the '+' sign next to the field name. It will get added to Y-axis automatically

    3. Click “Add another Axis” and repeat the two above steps to get fields for the second axis

  7. Click Run to view the results in the bottom pane (below is a screenshot of the multi-axis bar chart report)

  8. Click Save to save the report for future use. Saved reports can be accessed via My AreaMy Reports

Additional Details

Field Settings

Settings on each field can be set by selecting the gear icon on each added field. Listed below are some examples of the options that are available from field settings:

  • Change the label of the column

  • Apply filters on the column

  • Set date format

  • Set aggregation formula

Page Settings

Each page in a report can have a Page Title that will appear as the title of the page on the report. Page settings are also available for each page and differ based on the type of the report.

Sample Reports

  1. Simple Bar Chart - Count of issues in specified statuses (issue types specified in Optional Filters)

  2. Stacked Bar Chart - Count of Issues created last month, broken down by issue type

  3. Multi-series Bar Chart - Sprint Story Points details for all sprints of a specific project

  4. Multi-axis Bar Chart - Issues Created vs Issues Resolved for specified time interval

Related articles