Power BI Field Definitions

Find information on the Power BI datasets in Trimble Construction One Analytics.

Available Datasets

At this time, you can select the following Power BI datasets:
The following sections provide an overview of each dataset:

About the Spectrum: Service Dataset

The Spectrum: Service dataset provides information on service work orders, particularly useful for a Service Manager, Operations staff, or Equipment Manager. Note that this dataset uses a calendar date format, regardless of the Spectrum fiscal calendar.

There are a variety of dates within Service. The system uses the transactions date as follows:

  • For Billed Revenue and Flat Rate Revenue: Labor uses Transaction Date; Material uses the date it was brought into billing; Other Charges and Flat Rate use system date.
  • For Unbilled Revenue: The underlying cost transaction date is used for the unbilled revenue amounts.
  • For Labor, Material, and Other Costs: the system uses the cumulative and to-date totals for both posted and unposted transactions.

Transactions that originate outside of Work Order are not included in costs and billed numbers until the transactions are selected for billing.

Note the following for certain fields in the dataset:

  • Date Format: Calendar

  • Cost Centers: Work Order header level

About the Spectrum: Customer Billings Dataset

The Spectrum: Customer Billings dataset provides a consolidated source of all customer billings. This report is intended for the Controller or Accounting staff. It includes summary information such as Billed (amounts before taxes and retention), Invoiced (includes taxes), Paid, Retention, Retention Paid, Sales Tax, VAT. Customer, Customer Information, Customer Type and Transaction Source. This dataset contains posted transactions only; no unposted costs.

Note the following for certain fields in the dataset:

  • Date Format: Fiscal Calendar

  • Cost Centers: Invoice Header level

About the Spectrum: Vendor Financials Dataset

The Spectrum: Vendor Financials dataset provides a consolidated source of all vendor transactions. This report is intended for the Controller or Accounting staff. It includes summary information such as Billed (amounts before taxes and retention), Invoiced (includes sales tax), Paid, Retention, Retention Paid, Sales Tax, VAT, and Use Tax. Vendor, Vendor Information, Vendor Type are included as well. This dataset contains posted transactions only; no unposted cost support.

Note the following for certain fields in the dataset:

  • Date Format: Fiscal Calendar

  • Cost Centers: Invoice Header level