Pivot Tables
From SNCWiki
(Redirected from Pivot Table Reports)
| Reports |
|---|
| Related Topics |
 Get the Book |
Contents |
Overview
Pivot tables aggregate data from a table into columns and rows that you define. You can configure a filter to further refine the data and select the aggregation values to suit your needs. For detailed information, see Pivot Table Reports.
Report Record
To access the reports in your system, navigate to Reports -> View / Run. The report record for a pivot table looks like this:
|
Use the following fields to refine the data displayed in the report and to design the appearance of your pivot table:
| Field | Input Value |
| Name | Select a unique and descriptive name for your report. |
| Visible to | Select a group whose members are authorized to see the report or select Everyone to give all your users access. |
| Type | Select Pivot Table from the list. |
| Table | Select the Service-now table against which this report will be run. |
| Row | Select a field from the list as the source of the data for the rows in your pivot table. |
| Column | Select a field from the list as the cource of the data for the columns in your pivot table. |
| Aggregation | Determine how you want the data in the pivot table aggregated. The default is Count, which displays the number of records selected. When you select Average or Sum you can select from a list of additional fields whose values you want to use to aggregate your data. Typical values to use as an average or a sum are the time measurements, such as Business duration (expressed in days, hours, and minutes) and Resolve time (expressed in seconds). Other fields, such as Priority, may have numerical values associated with their levels and can be used as aggregators.
Note: If a value in a column being aggregated has a comma in it, the value will be separated by the comma, and the aggregation will not be performed accurately. |
| Other threshold | Use the values in this list to limit the number of records that appear in your table. The platform displays 12 records by default, from high values to low values and puts the remaining data into an Other category. You can select to display 10, 12, 15, 20, or all records. Click Remove Other to delete the Other category from your table. |
| Filter | Create conditions to filter your data. For example, you might want to restrict the data to incidents that were closed by a specific user or view high priority incidents. |
Report Options
Select a reporting option from the button bar above the form.
- Run Report: Creates the report from the data in the form.
- Update: Saves any changes to the form and returns you to the reports list.
- Save: Saves any changes to the form and leaves the form open.
- Insert: Duplicates a report record and inserts it into your reports list. Use this option to create a new report quickly by changing a few values in an existing report. Be sure to give your new report a unique name.
- Delete: Deletes the current report.
- Publish: Creates a URL for the report and displays the address above the report form. You can create an email notification with this URL and send the link to people who need to see the report. For details about publishing reports, see Publishing Reports
- Make Gauge: Create a gauge using the current report.
- Add to Homepage: Add the gauge you just made of the current report to the homepage.
- Schedule: Creates a schedule for running the current report. To view your report schedule records, navigate to Reports -> Scheduled Reports. You cannot schedule Pivot Tables or Calendars.
Notes/Limitations
- A pivot table will display no more than n columns of data where n = the value of the property glide.ui.chart.generate_other. If the underlying dataset contains more columns than that, the system will display a composite Other containing an aggregation for that data.
- A pivot table will display as many rows as there are rows to display.
- You may click on any non empty cell within a pivot table to drill through and see a detailed breakdown of those records.
- Empty cells are displayed in a lighter text color and are not clickable.
- It is possible for a cell to have a value, but for that value to be zero. For example, our aggregate is average of reassignment count, and all three hardware incidents assigned to Bob have a reassignment count of zero. In that case, there are three records behind that cell, but the aggregation value is zero. The zero is displayed in the normal font, and is clickable to drill through into those records.
- Non-empty cells have tooltips that alway report the counts behind each cell.
