Versions Compared

Old Version 11

changes.mady.by.user Jason Gauntz

Saved on

compared with

New Version Current

changes.mady.by.user Jason Gauntz

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Reverted from v. 10

he The Main tab in the Resolution/Root Cause Analytics dashboard helps you get a clear insight into what resolution and root causes are most frequent, how many work orders are associated with them for each trade, which regions need your close attention, and how many hours a provider spent on-site to complete the work orders. The Main tab offers the following reports:

You can use all-inclusive filters along the top of the dashboard to adjust the data to be displayed. You can also download the data and email reports to recipients.

Anchor
TopRRCVis
TopRRCVis
Top Resolution Codes and Root Cause Codes

These two visualizations display the 10 most frequent resolution codes and root causes that providers picked for work orders within a trade. Each visualization can be divided into two parts:

  • On the left are resolution codes or root causes showing the total count of work orders where they were added to. Hover over a resolution or root cause to see which trade they are linked to.
  • On the right are trades with the total count of work orders belonging to this trade. Hover over a trade to see all resolutions associated with it.

Switch between the tabs below to see how each visualization looks.

Rw ui tabs macro

Rw tab
titleTop Resolution Codes

Image RemovedTop resolution codes visualizationImage Added

Rw tab
titleTop Root Cause Codes

Image RemovedTop root cause codes visualizationImage Added

Clicking anywhere on the colored bar between a resolution or root cause and a trade allows you to:

  • Explore all work orders associated with a resolution or root cause
  • Filter work orders associated with a resolution or root cause by Region, Feedback, or Asset
  • Filter resolutions or root causes by Category or WO Tracking Number within a trade

Filtering options for resolution and root cause codes

Anchor
ResByWOandInvoiceByRegion
ResByWOandInvoiceByRegion
Regional Resolutions Selection by Work Order and Invoice

These are two stacked bar charts showing all resolution codes broken down by region. Each region appears as a stacked bar with its segments representing resolution codes displayed in different colors. You can visually compare the total number of work orders or the spent invoice amount (on the Regional Resolutions Selection by Work Order or Regional Resolutions Selection by Invoice bar chart, respectively) between the regions. When you hover over each resolution within a stack, you see the region name, resolution, and the total count or total invoice amount of associated work orders.

Switch between the tabs below to see how each stacked bar chart looks and which options you have to filter resolutions.

Rw ui tabs macro

Rw tab
titleRegional Resolutions Selection by Work Order

Image RemovedRegional resolutions selection by work orderImage Added

For instance, in the Southeast, providers completed 2 work orders where they replaced a compressor. Thus, the Replace Compressor resolution was added to those work orders. The same resolution was used for 2 work orders in the Midwest region (see the purple color in the bar chart).

Click any resolution within a stack to:

  • Explore all work orders associated with a resolution per region
  • Filter work orders associated with a resolution by Region, Feedback, or Asset
  • Filter resolutions by District within a region

Rw tab
titleRegional Resolutions Selection by Invoice

Image RemovedRegional resolutions selection by invoiceImage Added

For instance, in the Southeast, providers completed work orders for more than 4,000$ while in the Midwest region the spent costs are lower — around 3,500$. In the Southeast, 1,111$ was spent on work orders where providers replaced a compressor, while it was only 759$ in the Midwest.

Click any resolution within a stack to:

  • Explore all work orders associated with a resolution per region and check the invoice amounts of such work orders
  • Filter resolutions by District within a region

Anchor
SpendByResandRootCause
SpendByResandRootCause
Spend by Resolution and Root Cause

These two tables show how much time and money was spent to complete work orders per each resolution or root cause.

Switch between the tabs below to see how each table looks and which data it contains.

Rw ui tabs macro

Rw tab
titleSpend by Resolution

Spend By Resolution report on the Main tab

Rw tab
titleSpend by Root Cause

Spend By Root Cause report on the Main tab

  • Resolution / Root Cause. Name of the resolution code / root cause code — depending on the corresponding report type.
  • Total Selections. Total number of work orders with a resolution.
  • Min - Total Labor Hours. Minimum labor hours spent on each line item of invoiced work orders.
  • Avg - Total Labor Hours. Average labor hours spent on each line item of invoiced work orders.
  • Max - Total Labor Hours. Maximum labor hours spent on each line item of invoiced work orders.
  • Min - Total Labor Amount. Minimum labor amount spent on each line item of invoiced work orders.
  • Avg - Total Labor Amount. Average labor amount spent on each line item of invoiced work orders.
  • Max - Total Labor Amount. Maximum labor amount spent on each line item of invoiced work orders.

Anchor
commondatafeatures
commondatafeatures

Excerpt


Section



Commonly Used Features

Below is a quick reference guide regarding tracking numbers in Analytics, filtering, sorting, downloading data, and sending reports.

Tracking Numbers in Analytics

Throughout Analytics you can drill down into visualizations to see the underlying data. In most cases, the tracking numbers related to that data are listed. You can click the tracking number to navigate straight to the work order details in Service Automation.

Filtering Dashboards

On top of the report are all-inclusive filters to help you hone in on key data. All reports on the page are affected by the criteria set in these all-inclusive filters.

Note

The filter criteria for each dashboard may differ. Filters reset to the default when the page is refreshed.


Info
iconfalse


Expand
titleClick here to expand instructions on how to filter.


Panel
bgColor#F9F9F9
titleColor#0e3367
titleBGColor#EAEAEA
borderStylenone
title⦿ How to use Filters

  1. Click the triangle next to Filters to show the criteria.

  2. Select the desired criteria to include or exclude:

    1. To Include criteria: select is equal to, contains, starts with, or ends with, and then begin typing the criteria in the picklist. Select the desired criteria (or multiple criteria) from the picklist.

    2. To exclude criteria: select is not equal to, does not contain, does not start with, or does not end with.

      Note

      Is null depicts the absence of data in a data set. Conversely, is not null depicts the presence of data


    3. To include or exclude data without a certain data criteria — for example, to select data without a Region or District assigned in Service Automation — choose is blank / is not blank.

    4. To add more options, click the plus sign (+) next to a field to add another option to the filter. The new option will appear as either an OR condition or an AND condition, depending on the type of filter option.

  3. Once all criteria are selected, click Run in the top-right corner. The Dashboard report updates with the selected criteria.


Note

More details are available on Filtering an Analytics Dashboard



Dynamic Table Sorting

Analytics tables are dynamic, as you can: 

  • click column and row headers to sort data (the arrow indicate which data is sorted),
  • hover over a header to show the gear icon where you can interact with the data more dynamically, and
  • drag and drop a header to rearrange the table.

Image RemovedImage Added


Downloading and Sending Reports

Section


Column
width60%

In the upper-right corner of any page, click the Gear icon to download reports, send reports, or schedule reports to send at regular intervals.


Column
width40%


You can download data from a table and visualization or download a dashboard tabto PDF or CSV.

Info
iconfalse


Expand
titleClick here to expand instructions on how to download reports.


Panel
bgColor#F9F9F9
titleColor#0e3367
titleBGColor#EAEAEA
borderStylenone
title⦿ How to Download Data from a Single Visualization or Table
  1. On the desired table or visualization, hover over the upper-right to expose the 3 dots menu, and then click Download Data. The Download modal appears.

  2. Select the desired File Format and choose a File Name: A default name is listed but you can change it.

  3. Click Download.


Panel
bgColor#F9F9F9
titleColor#0e3367
titleBGColor#EAEAEA
borderStylenone
title⦿ How to Download a Dashboard to PDF

  1. On the desired dashboard (or dashboard tab), click the Gear icon in the upper-right of the page, and then click Download as PDF. The Download modal appears.

  2. A default Filename appears, but you can change it.

  3. Under Advanced options:

    1. Single-column format lays out all tables and visualizations on a page into one column in the PDF, as opposed to how it is laid out in the dashboard.

    2. Expand tables shows all rows in a table, instead of just the rows that appear on the dashboard.

    3. Paper size adjusts the PDF to your desired size.

  4. Click Open in Browser to view the PDF in your chosen browser, or click Download to save a version of the report onto your device.


Panel
bgColor#F9F9F9
titleColor#0e3367
titleBGColor#EAEAEA
borderStylenone
title⦿ How to Download a Dashboard to CSV Zip File

  1. On the desired dashboard (or dashboard tab), click the Gear icon in the upper-right of the page, and then click Download as CSVs... A new browser tab opens.

  2. After the files render, you are prompted to save the CSV Zip file onto your device.


Note

More details are available on Downloading and Sending Dashboards and Reports



You can also Send a one-time report via email or Schedule a recurring email send.

Info
iconfalse


Expand
titleClick here to expand instructions on how to send reports.


Panel
bgColor#F9F9F9
titleColor#0e3367
titleBGColor#EAEAEA
borderStylenone
title⦿ How to Send a Report Manually

  1. On the desired dashboard (or dashboard tab), click the Gear icon in the upper-right of the page, and then click Send. The Send (Dashboard Name) modal opens.

  2. A Title is given by default, but you can change it.

  3.  Under Who should it be emailed to?, enter the desired recipient(s), separated by a comma, and then click Add.

    1. (Optional) Click Include a custom message to add a personal note.

  4. Under Format data as, choose PDF, Visualization, or CSV Zip file.

  5. (Optional): Click Filters to limit the criteria that appear in the email. Note that the same filters on the dashboard itself will also appear here.

  6. Click Send. The email is sent to your recipients.


Panel
bgColor#F9F9F9
titleColor#0e3367
titleBGColor#EAEAEA
borderStylenone
title⦿ How to Schedule Reports

  1. On the desired dashboard (or dashboard tab), click the Gear icon in the upper-right of the page, and then click Schedule. The Schedule (Dashboard Name) modal opens.

  2. A Title is given by default, but you can change it.

  3.  Under Who should it be emailed to?, enter the desired recipient(s), separated by a comma, and then click Add.

    1. (Optional) Click Include a custom message to add a personal note.

  4. Under Format data as, choose PDF, Visualization, or CSV Zip file.

  5. Under Deliver this schedule, choose Daily, Weekly, Monthly, Hourly, or By minute (in 5-minute increments, up to 30 minutes)

  6. (Optional): Use Filters to limit the criteria that appear in the email. Note that the same filters on the dashboard itself will also appear here.

  7. Click Send. The email is sent to your recipients.


Note

More details are available on Downloading and Sending Dashboards and Reports






Live Search
spaceKeySCU
additionalpage excerpt
placeholderSearch our Knowledge Base
typepage

Panel
titleColor#ffffff
titleBGColor#5fa7d0
borderStylegroove
titleIn this Article

Table of Contents
maxLevel3
minLevel2
indent20px

Panel
titleColorwhite
titleBGColor#75a346
titleRelated Articles

Filter by label (Content by label)
showLabelsfalse
max8
showSpacefalse
sorttitle
cqllabel = "resolutioncodes" and space = currentSpace ( )