Follow

ID225 - Equipment MIF/Population Report by Territory/Technician Overview & Sample:

An on-demand report that shows the equipment population assigned to a territory in the equipment record. 

Jump to a specific section by clicking a link

Overview | Samples | Variables | Alert Functionality | OnDemand Report Filters | Best Practices & Tips | Related Alerts |

 

Click to Subscribe

Overview

Overview

ID225 is a report you run on demand that shows the equipment population assigned to a territory in the equipment record. Reports model, serial#, average monthly volume over the last 3 months, total calls over the last 6 months, and parts cost over the last 6 months, for each equipment, and totals for each model.

Note: This alert does require that you have ECIs' analytic tables installed and updated. See ID923 for a more detailed MIF SSRS report or ID771 Power BI Profit and MIF Analysis.

 

Run Schedule: On demand

Type of Output: On-Demand Custom Report

 

*  *  *

Sample

Sample

1) Territory 2) # of equipment 3) Parts cost 4) Average Monthly volume 5) Total Calls broken down by CM Corrective Maintenance, PM Preventative Maintenance, CC Courtesy Calls (call type categories)

1.png

 

*  *  *

Variables

Variables

This report has no variables

*  *  *

 

Alert Functionality

Alert Functionality

1. The report groups equipment using the Territory on the equipment record:

225_territory.png

 

*  *  *

 

OnDemand Report Filters

On-Demand Report Filters

Only include equipment on contract, OR include ALL active equipment:

2.png

Narrow down by certain equipment. Use the Advance Filter Option to look at certain models/model category:

Screen_Shot_2018-08-28_at_9.45.26_AM.png

4.png

Include all call history on the equipment, OR only look back a certain period:

5.png

Grouping Options for report output: i.e Territory, zip code then equipment OR Technician, zip code, model

6.png

*  *  *

 

Best Practices & Tips

Best Practices & Tips

None at this time.

*  *  *

Related Alerts

Related Alerts

ID771 - Profit and MIF Analysis (Power BI)

ID923 - Contract MIF Report (SSRS)

 

 

*  *  * 

 

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk