Work Order Avoidance Dashboard

Owned by Lamont Eddins
Last updated: Mar 21, 2023 by Caroline AntounVersion comment

Avoiding issuing a work order is always a great day! Even better is being able to determine how much is actually being saved. The Work Order Avoidance Dashboard allows you to receive a breakdown of avoided work orders and their savings cost. You can view and analyze when work orders are not needed and are classified in Dashboard 2.0. as either duplicates or troubleshooting work orders with support from Decision Tree on the Issue List. At any point in time, you can assess various savings scenarios in order to determine when and why issues are being resolved without the need of a work order. Doing so allows you to evaluate the needs for various locations and become creative with savings.


Even though the amount is shown in USD, it is not associated with a specific currency. It is taking amounts from various currencies and tallying the total as USD. For example, you may have a location in the United Kingdom and Japan, if the amount saved in the UK is £1000 and ¥1500 in Japan, it is converted as $1000 and $1500.


Work Order Avoidance Dashboard is comprised of the following sections:

# of Avoided WOs

# Avoided WOs displays the grand total of avoided work orders. This means the original work order was resolved without the assistance of a service provider. The grand total is broken down into three groups:

  • Duplicate WorkOrder
  • Problem Solved in Troubleshooting
  • Cancelled in Troubleshooting


Align center


Using the # of Avoided WOs grand total provides a list of all the solved issues whereas Duplicate Identified focuses only on duplicate work orders entered into Dashboard 2.0. and Problem Solved/Cancelled in Troubleshooting will showcase work orders solved by the Decision Tree.

⦿ How to View # of Avoided WOs
  1. From the top left-side column, select the # of Avoided WOs to view the report
    1. Select Duplicate Identified: to only view duplicate work orders
    2. Select Problem Solved in Troubleshooting: to only view work orders solved in Troubleshooting
    3. Select Cancelled in Troubleshooting: to only view work orders canceled in Troubleshooting
  2. A modal appears with the list of # of Avoided WOs

NTE of Avoided WOs

NTE of Avoided WOs determines the total estimated cost of work orders that would be submitted for maintenance or repair. The total cost is broken down into three groups:

  • Duplicate Identified
  • Problem Solved in Troubleshooting
  • Cancelled in Troubleshooting




The total amount of NTE of Avoided WOs gives you all the work orders that make up the amount. Further breakdown of the cost can be done by using Total NTE Duplicate WorkOrders, Problem Solved in Troubleshooting, and Cancelled in Troubleshooting.

⦿ How to View NTE of Avoided Work Orders
  1. From the middle columns, select the Total NTE of Avoided Work Orders Amount to view the report.
    1. Select Duplicate Identified: to only view duplicate work orders
    2. Select Problem Solved in Troubleshooting: to only view work orders solved in Troubleshooting
    3. Select Cancelled in Troubleshooting: to only view work orders canceled in Troubleshooting
  2. A modal appears with the list of NTE of Avoided WOs

Estimated Savings of Avoided WOs

Estimate Savings of Avoided WOs discovers how much on average a work order would have cost based on previous invoiced amounts for that trade. The average amount is broken down into Three groups:

  • Duplicate Identified
  • Problem Solved in Troubleshooting
  • Cancelled in Troubleshooting

This gives you insight on roughly how much actual savings you will have for not paying service providers for solved work orders. A detailed breakdown can be done with Duplicate WorkOrders, Problem Solved in Troubleshooting, and Cancelled in Troubleshooting.

⦿ How to View Total Estimated Savings of Avoided WOs
  1. From the right-side, column, select Total Estimated Savings of Avoided WOs to view the report 
    1. Select Duplicate Identified: to only view duplicate work orders
    2. Select Problem Solved in Troubleshooting: to only view work orders solved in Troubleshooting
    3. Select Cancelled in Troubleshooting: to only view work orders canceled in Troubleshooting
  2. A modal appears with the list of Total Estimated Savings of Avoided WOs
    Total Estimated Savings By Average Invoice Amount results

Avoided WOs by Trade

Avoided WOs by Trade establishes which trades are receiving the most problems solved along with the NTE and average invoice amount. You can evaluate avoided work orders by trade which is essential to assess the health of a location and better understanding how issues are being resolved.


⦿ How to View Avoided WOs by Trade
  1. Select 1 of the 3 to view the report:
    1. Avoided WOs Count
    2. Total NTE of Avoided WOs or
    3. Total Estimated Savings of Avoided WOs 
  2. Based on the selection, a modal appears with the list of Avoided WOs by Trade

# of Avoided WOs by Month

# of Avoided WOs by Month allows you to evaluate patterns with solved work orders based on a particular month. You can review a chart that exhibits a monthly total for all solved work orders. The chart shows the previous 11 months from the current month. 

⦿ How to View # of Avoided WOs by Month
  1. Select a month from the chart to view the monthly solved work orders
  2. A modal appears with the list of # of Avoided WOs by Month

Avoided Work Order Report

Avoided Work Order Report provides you with a detailed analysis of every work order that has been avoided. You are able to receive a complete line of information that pertains to the solved work order. This report combines all the additional reports together into a single report. 




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.

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

 Click here to expand instructions on how to filter.
⦿ How to use Filters

  1. Click filter field 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.

      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 Refresh icon in the top-right corner. The Dashboard report updates with the selected criteria.

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.


Downloading and Sending Reports

In the upper-right corner of any page, click the Vertical Ellipses to download reports, schedule delivery of reports at regular intervals, add to a board, or get a link.

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

 Click here to expand instructions on how to download reports.
⦿ 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.
⦿ 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.

⦿ 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.

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.

 Click here to expand instructions on how to send reports.
⦿ 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.

⦿ 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.

More details are available on Downloading and Sending Dashboards and Reports

In this Article

Related Articles