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 Filters menu. 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 filter to a single row, select it, and the other rows are grayed out.

For instructions on report-wide 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.

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.