intercept.md

api_name	excerpt	topics	api	hyperfunction	api_details
intercept()	Calculate the y-intercept from a counter aggregate	hyperfunctions	license type toolkit experimental version community function true false experimental stable 0.2.0 1.3.0	family type aggregates counters and gauges accessor counter_agg()	summary signatures parameters examples Calculate the y-intercept of a linear least-squares fit between counter value and time. This corresponds to the projected value at the PostgreSQL epoch `(2000-01-01 00:00:00+00)`. You can use the y-intercept with the slope to plot a best-fit line. language code sql intercept( summary CounterSummary ) RETURNS DOUBLE PRECISION required returns name type description summary CounterSummary A counter aggregate created using [`counter_agg`](#counter_agg) column type description intercept DOUBLE PRECISION The y-intercept of the linear least-squares fit description command Calculate the y-intercept of the linear fit for each 15-minute counter aggregate. code SELECT id, bucket, intercept(summary) FROM ( SELECT id, time_bucket('15 min'::interval, ts) AS bucket, counter_agg(ts, val) AS summary FROM foo GROUP BY id, time_bucket('15 min'::interval, ts) ) t