Monthly Trends—One Page per Year

Report-08 is a line chart (with data table) helps you compare multiple objects (meters, buildings, etc.) in the same year. For example, a line chart with a line for each electric meter for the year 2021.

Report 1 and 8 look similar at first glance but they work differently.

  • Report-01 compares multiple years for one object (a building's total commodity cost from 2015 to 2020).
  • Report-08 compares multiple objects for one year (several building's total commodity cost per month for 2020).


  • When you are reporting on Cost Avoidance, remember to run Cost Avoidance -> Calculate Savings first.
  • If you use chargebacks, remember to use the appropriate Topmost place or Topmost cost center to avoid double counting use or cost.


Use the filter Group by to set what each chart line represents. It many be necessary to set a filter for a topmost or group to limit the number of lines in the chart.

Set your filters

  1. Choose the type of data you want in your report with the Data type.
    • Billing Period Data uses the raw billing data as received from the utility vendor. Billing period data is better when working with accounting functions or charging departments for their portion of bill.
    • Calendarized data is more representative of monthly use and cost. For year-over-year COST comparisons use calendarized data.
    • Normalized is best when comparing USE year-over-year because it removes weather as a variable.
  2. Set First month with the month you want the report to start.
  3. Decide what each chart line represents with the filter Group by. It may be helpful to set a topmost or group to limit the number of lines on the chart.
  4. Decide if you want to Include account charges. Account line item charges are one-time or periodic charges. A charge is typically assigned at the account level when it does not have a link or relation to the use or demand on the bill.
  5. Set the Value.
  6. Set your Date range, try using prior year or prior 12 months so you don't have to reset this filter when using subscriptions or distributions.

Other filters to consider

  1. Do you want to include all the Commodities, one, or a select few? If you don't add this filter, all the commodities are in your report. Use the Commodity category filter to view more granular commodity data in charts and reports.
  2. Do you want to include only Active accounts? If this filter is not included your report includes both active and inactive.
  3. Include or not include void bills?
  4. You can limit the report to a subset of data, set a filter such as Topmost place, Building group, or Commodity

Configured Report-08 options

Report-08 is flexible and has many options available to configure. To help you be successful two configured reports are available to help get you started.

Each report has its own preset filters and instructions.