Service Spotlight: Asset Status Part 4: Usage Statistics

Now you have registered assets in the system, and you also now have inspections to track.  Let’s look at what you can do via Usage Statistics.

Click to Enlarge…

The first thing you will need to do is apply some filters, two of which need special mention: Month and Usage type.

When you select None in the month filter, the report will be for the entire year, broken down by month; Usage type is mandatory, so you will not be able to make a single report that encompasses the two Delivery Trucks (which track miles) and the Canadian Delivery Truck (which tracks kilometers) because the usage types are different.  “But wait,” you might be thinking, “It’s just distance, so can’t the system just convert kilometers into miles?”.  If you think that some assets will measure kilowatt hours, or other types of usage completely unrelated to distance, you can see why there is no way to lump them all in one big report.The three filters on the bottom row (Asset Types, Locations, and Assets) are all collapsible, and will reveal different information depending on what assets you have entered.

Let’s look at the yearly and monthly reports.

Click to Enlarge…

First, we are going to look at the yearly usage, so we are going to leave the Month filter as None and select Miles in the Usage Type filter.  Up until now, the Apply button was inactivated but once we do this, it becomes active.  Once we click on it, we get a total usage amount, and a graph breaking the usage down per month.

If you recall from the last section, our initial inspection reported 50 miles, establishing the baseline, and the second inspection reported 55 miles.  5 Miles is the difference between the two and that corresponds to our usage.  The graph shows those five miles were accumulated in May.

Now let’s take a look at the monthly breakdown.  Let’s select June in the Month filter and Kilometers in the Usage Type filter (we’re going to look at the Canadian truck this time).

Click to Enlarge…

Just like before, we have the total for the period selected (June) along with a graph tracking the daily usage throughout the month.

Finally, clicking the Data Table expandable header will reveal the raw data, broken down either by day or by month, depending on how this particular result was created.

Click to Enlarge…

You can use the search filter field to narrow down your results, and you can even export them to excel (note that the excel export will reflect your filter, so make sure the field is empty if you are after all the data.)

And that’s it!  You now have the knowledge and tools to register new assets, inspect them, supervise the results, and generate the statistics you need to keep tabs on your assets.

Service Spotlight: Asset Status - Jump to other pages within this Spotlight:

  1. Introduction
  2. Setup
  3. Status Control
  4. Usage Statistics
Fatal error: Uncaught Error: Cannot create references to/from string offsets in /storage/content/71/157571/ Stack trace: #0 /storage/content/71/157571/ separate_comments('') #1 /storage/content/71/157571/ comments_template('/comments.php', true) #2 /storage/content/71/157571/ include('/storage/conten...') #3 /storage/content/71/157571/ require_once('/storage/conten...') #4 /storage/content/71/157571/ require('/storage/conten...') #5 {main} thrown in /storage/content/71/157571/ on line 995