Report Template

Historian application analyzes all cells whose content is starting with $$ for a potential Historian formulas. The formulas are during the report generation evaluated and replaced by their value. Formula basically consists of a method name and a list of method parameters separated by comma and enclosed in braces. Each argument should be enclosed in quotes. List of supported formulas follow. Quick samples are at the end of the document.

• produces formatted date&time information
• supports two-argument syntax
  • TIMESTAMP
  • FORMAT
• or four-argument syntax
  • TIMESTAMP
  • NUMBER OF INTERVALS
  • INTERVAL_NAME
  • FORMAT

• evaluates the value of particular signal in database for requested timestamp
• supports two-argument syntax
  • SIGNAL_NAME
  • SIGNAL_TYPE
  • TIMESTAMP
  • FORMAT
• or four-argument syntax
  • SIGNAL_NAME
  • SIGNAL_TYPE
  • TIMESTAMP
  • NUMBER OF INTERVALS
  • INTERVAL_NAME
  • FORMAT

• lists a series of values of particular signal during requested time range
• supports nine or ten argument syntax
  • SIGNAL_NAME
  • SIGNAL_TYPE
  • TIMESTAMP_START
  • TIMESTAMP_END
  • AGGREGATION_METHOD
  • AGGREGATION_INTERVAL
  • NUMBER OF INTERVALS
  • ORIENTATION
  • FORMAT
  • INCLUDE_HEADER (as of version 1.9.7, optional)

• evaluates a totalized value of particular signal during requested time range
• supports six-argument syntax
  • SIGNAL_NAME
  • SIGNAL_TYPE
  • TIMESTAMP_START
  • TIMESTAMP_END
  • AGGREGATION_METHOD
  • AGGREGATION_INTERVAL
  • NUMBER OF INTERVALS
  • ORIENTATION
  • FORMAT

• TIME_STAMP
  • CURRENT
  • START_OF_DAY
  • START_OF_MONTH
  • START_OF_YEAR
  • LAST_DAY
  • LAST_MONTH
  • LAST_YEAR
• FORMAT
  • Date&Time formatting (see https://msdn.microsoft.com/en-US/library... for a complete listings):
    • dddd – week day name
    • MMMM – month name
    • dd – two-digit day number
    • MM – two-digit month number
    • yy – two-digit year number
    • yyyy – four-digit year number
    • HH – two-digit hour number (24-hour system)
    • mm – two-digit minute number
    • ss – two-digit second number
  • Numbers formatting (see https://msdn.microsoft.com/en-us/library... for a complete listings):
    • 0 – produces whole rounded numbers
    • 0.0 – produces numbers rounded to one decimal point
    • RAW – cell content is set to exact calculated number
  • All other characters should be escaped by preceding slash (eg. “0 \k\g\/\s” for value of 10 produces “10 kg/s”)
• INTERVAL_NAME
  • SECOND
  • MINUTE
  • HOUR
  • DAY
  • MONTH
  • YEAR
• AGGREGATION_INTERVAL
  • PER_SECOND
  • PER_HOUR
  • PER_MINUTE
  • PER_DAY
• AGGREGATION_METHOD
  • Average
  • Count
  • StdDev
  • Variance
  • MinimumActualTime
  • Minimum
  • MaximumActualTime
  • Maximum
  • Total
  • TimeAverage
  • Interpolative
  • End
  • Delta
  • Range
  • TXP
• TOTALIZE_INTERVAL
  • PER_SECOND
  • PER_MINUTE
  • PER_HOUR
  • PER_DAY
• ORIENTATION
  • TO_RIGHT
  • TO_DOWN

For a report generated with decisive time 6.12.2016 00:03:00 following formulas will produce values: