StackHub Bulletin BoardAdvertise your announcements here!

Allows you to look for strange or missing values in SkySpark.

sfxDataQualityExtAxon funcs

Registered StackHub users may elect to receive email notifications whenever a new package version is released or a comment is posted on the forum.

There are **3** watchers.

v2.3.0

sfxDQFindNoise

sfxDQFindNoise(thePoint, dates, delta: 0%, dur: 16min)

Find Noise

- This rule runs at the point level.
- This rule looks for data groups that have changed by a certain percentage from a previous group.
- The percentage will be determined automatically if no delta and dur parameters are given.
- Side Effects: None.
- Input: A point, a date/date range, an optional delta, and an optional duration.
- Output: hisDurGrid
- sfxDQFindNoise(read(temp and discharge), pastMonth)
- sfxDQFindNoise(read(temp and discharge), pastMonth, 5%, 30min)

sfxDQFindNulls

sfxDQFindNulls(thePoint, dates, interval: 15min)

Find Missing Values

- This rule runs at the point level.
- Do rollups of the expected interval of the data. Then, look for empty periods.
`sfxDQTSGap()`

does the same thing, but is more advanced.- Side Effects: None.
- Input: A point, a date/date range, and an expected interval.
- Output: hisDurGrid
`sfxDQFindNulls(read(temp and discharge), pastMonth, 20min)`

sfxDQFindOddities

sfxDQFindOddities(thePoint, dates)

Find Oddities

- This rule runs at the point level.
- Finds nulls, NAs, or numbers less than or equal to 0.
- Side Effects: None.
- Input: A point and a date/date range.
- Output: hisDurGrid
`sfxDQFindOddities(read(temp and discharge), pastMonth)`

sfxDQFindOutliers

sfxDQFindOutliers(thePoint, dates, sDs: 3)

Find Outliers Based on Standard Deviation

- This rule runs at the point level.
- This rule has been modified to rely on the hisDQAverage and hisDQstdDev tags that come from the DQJob.
- sDs is the number of standard deviations you want this rule to allow for before a spark is detected. If a history record is below or above 3 stdDev, it will cause a spark in this form (you can change this).
- Side Effects: None.
- Input: A point, a date/date range, and optionally, how many standard deviations to go out.
- Output: hisDurGrid
`sfxDQFindOutliers(read(temp and discharge), pastMonth, 4)`

sfxDQJob

sfxDQJob(reInitialize: 1mo, dateRange: pastYear, filter: "point and kind==\"Number\" and hisSize > 1", modeInterval: 1)

Data Quality Job

- Adds Descriptive Tags to Numeric Points
- Run this as a job weekly
- reInitialize tells SkySpark how often to update tags
- Descriptive tags can be modified by user on the fly or with tuning function.
- Monthly running yearly total normalizes for many things.
- Dependencies: Calculus and Signal Analysis Pods.
- Side Effects: Adds several statistical tags to all numeric points that can be used for complex rules.
- Input: Optional reInitialize interval and option how far back to go (default is 1mo and pastYear).
- Output: None.
`sfxDQJob()`

sfxDQMismatchedEnergyUsage

sfxDQMismatchedEnergyUsage(thePoint, dates, buffer: 0.8)

Find Where Energy Out is not in Line with other Records

- This rule runs at the point level.
- Use tags from data quality job to look for energy in/out outliers.
- This rule is currently designed to run on
`zone air temp sensor`

points and then go to the equip (usually ahu) level, find the`weatherPoint temp`

(via`siteRef`

and`weatherRef`

) and finally the`siteMeter energy point`

- Side Effects: None.
- Input: A
`zone air temp point`

, a date/date range, and optional buffer. - The buffer determines what percentage of the pastYear's absolute min or max is acceptable. if old: {min: 50, max: 100, buffer: 0.8} then run against: {minThresh: 62.5, maxThresh: 80} (50/0.8 = 62.5 and 100*0.8 = 80)
- Output: hisDurGrid
`sfxDQMismatchedEnergyUsage(read(zone and air and temp and sensor), pastMonth, 0.7)`

sfxDQOutlierThresh

sfxDQOutlierThresh(thePoint, dates, threshold: 1000)

Find Values too High.

- This rule runs at the point level.
- Find Outliers based on threshold and its inverse.
- Dependencies: None.
- Side Effects: None.
- Input: A point, a date/date range, and a threshold.
- Output: hisDurGrid
`sfxDQOutlierThresh(read(temp and discharge), pastMonth, 100)`

sfxDQOutofRange

sfxDQOutofRange(thePoint, dates, buffer: 0.8)

Find Outliers

- This rule runs at the point level.
- Use tags from data quality job to look for outliers.
- Side Effects: None.
- Input: A point, a date/date range, and optional buffer.
- The buffer determines what percentage of the pastYear's absolute min or max is acceptable.
- if old: {min: 50, max: 100, buffer: 0.8} then run against: {minThresh: 62.5, maxThresh: 80} (50/0.8 = 62.5 and 100*0.8 = 80)
- Output: hisDurGrid
`sfxDQOutofRange(read(temp and discharge), pastMonth, 0.7)`

sfxDQRateofChange

sfxDQRateofChange(thePoint, dates, buffer: 0.8)

Find Rate of Change too High

- This rule runs at the point level.
- sfxDQRateofChange() does the same thing, but is more advanced.
- Use tags from data quality job to look for rate-of-change outliers.
- Dependencies: Calculus and Signal Analysis Pods.
- Side Effects: None.
- Input: A point, a date/date range, and an optional buffer.
- The buffer determines what percentage of the pastYear's absolute max negative or max positive rate of change is acceptable.
- if oldROC: {maxNegROC: -10, maxPosROC: 10, buffer: 0.8} then run against: {maxNegROCThresh: -8, maxPosROCThresh: 8} (-10*0.8 = -8 and 10*0.8 = 8)
- Output: hisDurGrid
`sfxDQRateofChange(read(temp and discharge), pastMonth, 0.7)`

sfxDQRateofChangeThresh

sfxDQRateofChangeThresh(thePoint, dates, threshold: 5)

Find Rate of Change too High

- This rule runs at the point level.
- Use tags from data quality job to look for rate-of-change outliers.
- Dependencies: Calculus and Signal Analysis Pods.
- Side Effects: None.
- Input: A point, a date/date range, and a threshold.
- Output: hisDurGrid
`sfxDQRateofChangeThresh(read(temp and discharge), pastMonth, 10)`

sfxDQTSGap

sfxDQTSGap(thePoint, dates, buffer: 1.9)

Find Gaps in Data

- This rule runs at the point level.
- Use tags from data quality job to look for missing data/intervals.
- Side Effects: None.
- Input: A point, a date/date range, and an optional buffer.
- The buffer determines what percentage of the pastYear's median ts interval is acceptable.
- if oldTSInt: {medTSInt: 15min, buffer: 1.9} then run against: {medTSIntThresh: 28.5min} (15min*1.9 = 28.5min)
- Output: hisDurGrid
`sfxDQTSGap(read(temp and discharge), pastMonth, 1.8)`

sfxDQZScoreOutofBounds

sfxDQZScoreOutofBounds(thePoint, dates, buffer: 0.8)

Find Outliers using ZScore

- This rule runs at the point level.
- Use tags from data quality job to look for outliers.
- Side Effects: None.
- Input: A point, a date/date range, and optional ZScore override.
- Output: hisDurGrid
`sfxDQZScoreOutofBounds(read(temp and discharge), pastMonth, 0.9)`

Published by SkyFoundry

v1.5.0

sfxCalculusExt

Allows you to perform calculus on numerical and boolean history grids in SkySpark.

by SkyFoundry