The name of the Value History Service from which to retrieve data. Use … to select the service.

• Earliest Time is the starting date/time, or how far back to go for data. Type a value in the field or use … to display a calendar.
• Latest Time is the ending date/time, or the most recent date. Type a value in the field or click … to display a calendar. The default time is midnight if a time is not specified.

The date range can be specific or you can use date wildcards. A date wildcard allows the export to be dynamic and eliminates the need to edit the date parameters every time the export is run. The date wildcard is "T" (for "today"). You can subtract from T to go back. T-7 represents seven days ago. Therefore, a range of “T-7 to T” would be seven days ago to today.

Specifies the type of values to include in the report.

• If Raw Values is selected, only raw data will be exported.
• If Rollup Values is selected, you specify the rollup type for each tag on the Tags page. See History Rollups for more information about rollup types.

Rollup Units and Rollup Period specify the period to which the data will be calculated or thinned. Rollup Types are defined on the Tags page.

Example 1

If you set the Rollup Type to Raw or any Calculated type, and the date range on the report is 14 days, and you set the Rollup Units to Minutes and the Rollup Period to 30, the data would be rolled up to 30 minute periods for the 14 days.

• Raw would return the middle value from the set of values for the 14 days
• Calculated Weighted Average would return a time-weighted rolling average from the values for the 14 days
• Calculated Mean would return a simple average of the values collected for the 14 days
• Calculated Min would return the minimum value from the values collected for the 14 days
• Calculated Max would return the maximum value from the values collected for the 14 days
• Calculated Delta would return the difference between the minimum and maximum values from the values collected for the 14 days
• Calculated Last would return the last value from the values collected for the 14 days

Example 2

If you set the Rollup Type to any thinned type, and the date range on the report is 14 days, and you set the Rollup Units to Minutes, and the Rollup Period to 30, the raw data would be thinned to data values for every 30 minute period for the 14 days:

• Thin Median would return the middle value from the set of values for the 14 days
• Thin Min/Max would return the minimum and maximum values from the set of values for the 14 days
• Thin Last would return the last value from the set of values collected for the 14 days

Top of Subunit is an offset from the normal date/time. It provides a method to allow for start of day, time zone, or scheduling differences. For example, if you are using a rollup period of 1 day, and your data day starts at 8:00 A.M. (instead of midnight), you can offset the period by entering an "8" in this field. Note that this field uses 24-hour time.

Filter Raw Values

When the UIS cannot communicate with a device, the last known values from the device are marked as unreliable. When Exclude Unreliable is enabled, only reliable data is exported.

By default, data is reported to the historian on an exception basis (value or status change). If you override this setting for a tag by using the reporting options in the Point Service (PNT), the history service may have unchanged data. When Exclude Unchanged is enabled, only changed values are exported.