clickhouse-docs icon indicating copy to clipboard operation
clickhouse-docs copied to clipboard

Document `expXYZ` functions.

Open johnnymatthews opened this issue 1 year ago • 1 comments

Create documentation for the expXYZ function:

  • [ ] exp
  • [ ] exponentialTimeDecayedAvg
  • [ ] exponentialTimeDecayedCount
  • [ ] exponentialTimeDecayedMax
  • [ ] exponentialTimeDecayedSum

See #1833 for details on how to complete this issue.

Child issue of #1833.

johnnymatthews avatar Feb 11 '24 19:02 johnnymatthews

@johnnymatthews I'll pick this one up.

Blargian avatar Apr 04 '24 21:04 Blargian

@excitoon I'd like to add documentation for the following functions:

  • exponentialTimeDecayedSum
  • exponentialTimeDecayedMax
  • exponentialTimeDecayedCount
  • exponentialTimeDecayedAvg

As I saw they are all exponentially smoothed moving window functions. Could you tell me something about how Avg, Sum, Max and Count differ from each other in terms of implementation? (If you have any references to formulas it would be great). How does exponentialTimeDecayedAvg differ from exponentialMovingAverage?

Blargian avatar Jun 13 '24 12:06 Blargian