Examples

<< Click to Display Table of Contents >>

EQuIS 7  >>  Enterprise > EQuIS Live > Agents > Data Computation >

Examples

{ sourceSeriesId: [130041], value: "d.datum_value + equis.fn_logger_measure_datum(@facility_id, @sys_loc_code, d.datum_utc_dt)" }
 
Computed series datum = source series (LOGGER_SERIES_ID = 130041) datum + the result of function equis.fn_logger_measure_datum(...).

 

{ sourceSeriesId: [130041, 130032, 130033], value: "MAX(d.datum_value + equis.fn_logger_measure_datum(@facility_id, @sys_loc_code, d.datum_utc_dt))", procedure: "EXEC [equis].[sp_insert_dt_water_level_daily_max] @target_series_id, @start_date, @end_date, @facility_id, @sys_loc_code;" }
 
See Example 1. An aggregate function - MAX, in this example - is needed in case more than 1 source datum has the same DATUM_UTC_DT.

 

{ sourceSeriesId: [130041, 130032, 130033], procedure: "EXEC [equis].[sp_insert_dt_logger_datum_plus_measure] @target_series_id, @source_series_ids, @start_date, @end_date, @facility_id, @sys_loc_code;" }
 
See Example 2.

 

{ sourceSeriesId: [130091, 130092], value: "SUM(d.datum_value)" }
 
or
 
{ sourceSeriesId: [130091, 130092], value: "SUM(?)" }
 
Series 130091 = raw data, series 130092 = offset; computed series = series 130091 + series 130092.

 

{ sourceSeriesId: [187381936], procedure: "EXEC [equis].[sp_percent_uptime] @target_series_id, @source_series_ids, @start_date, @end_date;" }
 
See Example 3.