Weekly Change Log: July 10, 2017 - July 16, 2017

ATSD

Issue Category Type Subject
4390 sql Bug Fixed CAST conversion error with the built-in time column.
4375 sql Feature Added support for CURRENT_TIMESTAMP and DBTIMEZONE functions.
4360 forecast Feature Added support for additional aggregation functions in forecast settings: AVG, MIN, MAX, SUM, COUNT.

Issue 4375

The CURRENT_TIMESTAMP function returns current database date and time in the ISO 8601 format similar to the NOW function which returns current database time in Unix milliseconds.

The DBTIMEZONE function returns the current database time zone name or GMT offset.

Issue 4360

A custom aggregation function such as MAX can now be selected in Forecast settings. Previously only AVG function was supported. Aggregation functions are applied to regularize the underlying time series prior to applying H-W or ARIMA algorithms.

AVG

Averages the values during a period.

MAX

Displays the maximum value during a period.

MIN

Displays the minimum value during a period.

SUM

Sums the values during a period.

COUNT

Displays the number of samples for a period.