::SMOOTH
Dashboards: browser · CLI · servers
Community extension: anofox_render


Scatter + trend line (LOESS; ::SMOOTH_METHOD ‘lm’/‘gam’).
Also spelled: ::TRENDLINE, ::TREND_LINE
The data it needs
Section titled “The data it needs”One row per observation: ::XAXIS and the measure, both numeric. Draws the points and a LOESS trend ('lm'::SMOOTH_METHOD for a straight line).
SELECT x ::XAXIS, x * 0.5 + sin(x) * 3 ::SMOOTH FROM range(0, 40) r(x);In an example
Section titled “In an example”From Which chart fits which question? — open it in the builder ↗:
SELECT 6::COL; SELECT day::XAXIS, y::SMOOTH, 'Scatter + LOESS trend (::SMOOTH)'::TITLE FROM ts ORDER BY dayRelated
Section titled “Related”::LINECHART · ::LINECHART_PERCENT · ::STEP · ::AREACHART · ::AREACHART_STACKED · ::CANDLESTICK · ::SPARKLINE · ::SPARKBAR