Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The Service Providers Analysis tab gives you a view of your facilities spend by Provider. Across your active providers, you can analyze invoice amounts, feedback, service levels, and trades over the past 365 days, by default. Use the all-inclusive filters along the top of the report to change the date range, or to focus on specific Trades, Categories, and/or Providers.

Image Added

In this dashboard you will see:

You can download the data and email reports to recipients.

Image Removed

Anchor
activeprovs
activeprovs
Count of Active Providers

Section


Column
width30%

Image Added


Column
width70%

This visualization displays the

Number

number of Providers who have

been worked with during selected date range

worked on at least 1 work order during the selected date rangeBy default, this chart displays this data over the past 365 days; use the all-inclusive filters along the top of the report to change the date range.

Clicking the number drills down into a list of all work orders and includes:

  • work order details such as Status, Trade, Category, and Location
  • work order completion date
  • NTE
  • Invoice Amount
  • Committed Spend

Clicking the tracking number navigates you the work order details page in Service Automation.


Anchor

analysistoptenbytotal

toptenbubble

analysistoptenbytotal

toptenbubble
Provider Analysis - Top 10 by Total Invoice Amount

bubble chart displaying three dimensions of data:

Section


Column
width40%

This visualization enables you to spot any outliers among your provider invoicing. It clusters three-dimensional data for your top 10 Providers: Invoice Amount, Average Invoice Amount

and

, and Number of Work Orders by Provider

(top 10 Providers by total Invoice Amount). Horizontal axis reflects Invoice Amount. Vertical axis is Average Invoice Amount axis. And the Number of Work Orders as an additional dimension of the data is represented in the size of the bubbles. Each bubble is associated with separate Provider.  Hovering the mouse pointer over any bubble shows the numbers for corresponding Provider.
Info
Both voided work orders and work orders with an empty Status are excluded.

.

Info

Both voided work orders and work orders with an empty Status are excluded.

Each bubble represents a Provider — the more Work Orders for that Provider, the larger the size of the bubble. 

Hovering over a bubble lists the Total Invoice Amount for that Provider, the Provider name, the Average Invoice Amount, and the total Work Order Count. Clicking the bubble allows you to explore all underlying data, or filter by TradeDistrict, or Asset.

By default, this chart displays this data over the past 365 days; use the all-inclusive filters along the top of the report to change the date range. 


Column
width60%

Image Added


Anchor
provfeedbkrpt
provfeedbkrpt
Feedback Report 

pie chart displaying the Number of Work Orders by the Feedback Result. Only WOs with 'Completed' or 'Invoiced' Status and empty or 'Confirmed' Extended Status

Section


Column
width60%

Image Added


Column
width40%

This visualization summarizes the number of work orders marked as Satisfactory or Unsatisfactory, as well as work orders with no feedback.

Info

Only work orders in the Completed, Completed/Confirmed, and Completed/Invoiced Statuses are included.

Hovering

the mouse pointer

over the chart

opens Number of Work Orders for corresponding WO Feedback Result. Anchortoptenbyinvamttoptenbyinvamt

shows the number of work orders for the corresponding feedback result. Click a feedback result to drill down into all work orders with that result, or filter work orders by Region, Feedback, or Asset.

By default, this chart displays this data over the past 365 days; use the all-inclusive filters along the top of the report to change the date range. 


Anchor
toptentable
toptentable
Top 10 Providers by Total Invoice Amount

table displaying total Number of Work Order, total Number of Invoices, Average Invoice Amount,

Image Added

This table helps you analyze your top 10 providers and their work order and invoice volume. For each Provider you will see:

Section


Column
width20%
  • Work Order Count
  • Invoice Count
  • Average Invoice Amount


Column
width80%
  • Average Full Resolution Time (Days
) (WO Completiondate - WO Calldate), Average Hours on Site, Total Invoice Amount and
  • ), calculated as the difference between the Work Order Completion Date and Work Order Call Date
  • Average Time on Site (Hours)
  • Invoice Amount
  • Average Time to Invoice (Days)

 (Invoice Posteddate - WO Completiondate) for top 10 Providers by Total Invoice Amount. WOs in 'TRN-EXCLUDE', 'VOID' and empty Status are excluded.
  • calculated as the difference between the Invoice Posted Date and Work Order Completion Date



Info

Both voided work orders and work orders with an empty Status are excluded.

By default, this chart displays this data over the past 365 days; use the all-inclusive filters along the top of the report to change the date range. 

Clicking any of the data points will drill down further into the data, based on that header. To navigate to work order details, click either data under WO Count or Invoice Amount for that Provider. 

Anchor
srvlevelsbytrade
srvlevelsbytrade
Service Levels by Trade - Top 10 by WO Count

able displaying

Average Hours on Site for
Section


Column
width40%

Image Added


Column
width60%

This table shows the total Average Full Resolution Time (Days)

 (WO Completiondate - WO Calldate) and 

and Average Time on Site (Hours) for the top 10 Trades

by the Number of Work Orders

, by work order volume. Work Orders in the Completed or Invoiced Statuses appear here.

Info

Both voided work orders and work orders with an empty Status are excluded.

Clicking on the Trade allows you to drill down into the data by Category or Tracking NumberClicking a metric drills down into a list of all work orders and includes:

  • work order details such as Status, Trade, Category, and Location
  • work order completion date
  • NTE
  • Invoice Amount
  • Committed Spend

By default, this chart displays this data over the past 365 days; use the all-inclusive filters along the top of the report to change the date range. 


Anchor
invanalysisbytrade
invanalysisbytrade
Invoice Analysis by Trade - Top 10 Trades by

count of invoicestable displaying 

Count of Invoices


Section


Column
width60%

This table lists the Average Invoice Amount,

 total Number

 total number of Invoices, and total Invoice Amount

 for

 for the top 10 Trades by total Invoice Amount.

 

Here, you can see where most of your facilities spend is allocated, by Trade.

Clicking on the Trade allows you to drill down into the data by Category or Tracking Number. Clicking other metrics allow you to either see all of the data or filter by Trade, District, or Asset.

Info

Voided work orders are excluded.

By default, this chart displays this data over the past 365 days; use the all-inclusive filters along the top of the report to change the date range. 


Column
width40%

Image Added



Anchor
commondatafeatures
commondatafeatures

Insert excerpt
All Calls Tab
All Calls Tab
nopaneltrue

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

Image Modified

Panel
titleColorwhite
titleBGColor#75a346
titleRelated Articles

Filter by label (Content by label)
showLabelsfalse
max8
showSpacefalse
sorttitle
cqllabel = "label" in ( "enhancedanalytics" , "analytics" , "insite" , "dashboards" ) and space = currentSpace ( )