The Advanced tutorial highlights features available to those with a higher level of comfort with the MC Reporter:
A highlight from this tutorial includes the lesson on Custom Expressions explaining how to use a custom expression to perform a calculation, such as the number of days that a work order has been open. This lesson also includes a reference table of commonly used custom expressions:
The lesson on Custom Group Headers also provides a helpful tip regarding how to group report data by date aggregations, such as month or year:
The Pivot Report tutorial provides instructions on creating a special kind of summary report that allows for the aggregation of data along two dimensions, such as type and priority:
Pivot reports can also be used to present time periods in logical date aggregations (monthly, quarterly, etc.). The tutorial will teach you how to create a report such as the following, calculating actual labor hours worked in each month for work orders of a given priority:
The skills presented in the Reporter Tutorials will provide you with the expertise to extend the reporting capabilities of MC v6.0 at your organization. The Maintenance Connection Support Team looks forward to assisting you as you expand your skills with the Reporter!