The Equipment Summary report provides summary and detailed information about cost and revenue generated by equipment.

The Equipment dashboard has four different tabs, Summary, Cost, Revenue, and detail.

Note that in each tile, you can scroll down to view each item. You can also hover over an item to view the details for that item.

You can filter the report using the parameters in the four menus shown. Note that you can also display the information as a table by selecting a data point, right-clicking, and selecting Show as a table.

To spotlight a single row, select it, and the other rows are grayed out.

For instructions on filtering, see Filter a Standard Power BI Report.

To learn about the different options for interacting with the tiles in a Standard Power BI Report, see Standard Power BI Report Options.

To spotlight a single row, select it, and the other rows are grayed out.

See the video below for a visual walkthrough of each tab.

Summary Tab

The Summary tab provides totals for revenue, cost, budgeted cost, and hours across all equipment. It also provides a variety of graphs, which include the cost and revenue by Equipment Type, Equipment Code, and Date.

Cost Tab

The Cost tab provides a variety of metrics related to equipment cost. This includes totals for cost and fuel use, as well as graphs showing cost by Equipment Code; fuel used by Equipment Code and Fuel / Oil Type; and cost by Date.

Revenue Tab

The Revenue tab provides a variety of metrics related to equipment revenue. This includes totals for revenue and hours, as well as graphs showing revenue by Equipment Code and Revenue Type; hours by Equipment Code and Usage Type; and revenue by Date.

Detail Tab

The Detail tab provides the raw data for all equipment details. It includes columns for Equipment Code, Equipment Description, Cost, Fuel Used, Revenue, Hours, Equipment Type, Division, Equipment Year, Make, Model, Weight Class, Weight Class Description, Weight Class Unit of Measure, Equipment Status Code, Equipment Original Cost, Purchased Date, Purchase Condition, Road Usage, Standard job Rate, and Standard Rental Rate.