Trend charts can display up to 10,000 rows of data. However, users may need to display trends over time that contain data in excess of 10,000 rows. In these cases, you must rollup the data. Rolling up data summarizes several rows of data into a single value, allowing you to display greater ranges of information without affecting performance.

For example, a chart has 5 points and trends at a 15-minute interval. This trend can display about 4 months of data before it hits the 10,000 limit, where roughly 2,000 rows are returned each month. A chart configured like this may be suitable without using the rollup function.

In another example, a chart has 5 points, where 4 are trending at 15-minute intervals and 1 is collecting COV data. The point collecting COV data will return at different times than the 4 points collecting at 15-minute intervals. Therefore, the return of data will be greater in a month and will hit the 10,000 row limit sooner than the chart configured in the example above. To show the full range of data, use the rollup function. In this scenario, you would rollup the data collected by the COV point to display data collected at 15-minute intervals.

  • Trends is selected.
  1. Locate the desired chart view in the building structure and select it to display the trended data.
  1. Select > to display the Series options dialog box.
  1. Use the Interval drop-down menu on the point that needs to be rolled up. Common best practices based on the range include:
  • Day: Select a 15 minute, 30 minute, or hour interval.
  • Week: Select a 15 minute, 30 minute, hour, or day interval.
  • Month: Select a 15 minute, 30 minute, hour, day, or week interval.
  • Year: Select an hour, day, week, or month interval.