Getting started with creating reports and charts

This topic provides a high-level overview of the steps for using the report builder. For more information, see the following topics:

• Selecting-the-fields-to-show-in-a-custom-report
• Applying-a-layout-to-rows-and-columns-in-a-report
• Aggregating-results-grouping-values-summarizing-and-transforming-results
• Performing-calculations-on-fields-in-a-report
• Organizing-reports-in-sections
• Applying-a-filter-to-data-in-report-fields

The following video (7:09) describes how to create a basic report.

 https://youtu.be/8hfLJ_SNU5g

The following two-part video series describes how to create a report and add charts to it.

 Perform the following steps to create a report by using the report builder:

Step 1: Select a view

The first step in building a report is selecting the view:

1. On the main menu, select Create > Report.
2. In the New Report window, select a view. For example, Incident Management.
   Use the fields defined within the view to create the report.

Step 2: Define the fields, filters, and display options for the report

Use the Data tab to define the look and feel of a report, the fields to display, the filters to use, and determine whether a chart or drill through should be displayed. The following steps use fields from the Incident Details folder.

1. In the left navigation panel, expand the Incident Details folder.
2. Drag and drop the Incident ID field into the preview area.
   You can also drag the field directly into the Column or Rows list. 
3. Expand the Incident Owner category and drag the Submitter field next to the Incident ID field to the Preview area.
4. Expand the Date and time category and drag the Reported Date field to the Rows area.
5. On the main Formatting bar, click the Column Formatting icon to adjust the title and formatting options applied to the fields in the report.
6. Select the Incident ID field, and change the Display name of the field to Incident No.
7. Click the X button on the top-right corner of the Column Formatting menu to close it and apply changes. 

Step 3: Build charts

Use the Charts tab to build visualizations based on the table created on the Data tab. Perform the following steps after defining the fields, filters, and display options of the report.

1. To progress to the Chart Builder step, click the Charts tab.
   On the left side, a list of fields appears from the fields you selected in the Data step.
2. Drag the Reported Date field to the Horizontal Axis component.
3. Drag the Incident No field to the Vertical Axis component.
   A line chart is generated. To change the chart type manually, switch from the Auto Chart builder to a specific type.
4. Open the Select Chart panel on the right of the screen.
5. In the Pie section, select a basic Pie Chart.
6. To enable labeling:
   1. In the main navigation bar, select the Labels formatting menu.
   2. Turn on the Labels toggle.
   3. For Label Contents, select Category and Percentage.
7. Click X to close the menu and apply your label settings.
8. Create relationships between the draft report and other content by using Drill Through and Co-Display reports.

Step 4: Design the report's format

The Design tab enables you to format the report, set up a multi-chart canvas, and perform other functions. 

1. Click the Design tab.
2. Use the icons in the middle of the navigation bar to configure settings such as Report Formatting, Column Formatting, and Conditional Formatting.

Step 5: Publish the report

With the Publish tab, you can save the report.

1. Enter a name and description, and select a location to save the report.
2. Set Report Access to Public.
3. Click Save As Draft.