[Libreoffice-bugs] [Bug 139856] CALC CHART Trend Lines for moving average not being "smoothed" similarly to Polynomial Trend Lines

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=139856

--- Comment #6 from Colin <that.man.colin at gmail.com> ---
(In reply to Louis Steinberg from comment #5)
> Here is a workaround:  Add a column D to your spreadsheet which calculates a
> running average of column C and add it as to the plot separately as a
> smoothed line.

Hi Louis and thanks for your endeavours: I have already added columns for
3,7,10&14 event moving averages - 5664 "surplus" cells with a daily "growth"
rate of +20 for the four new data elements. 400% overhead for smooth lines :(.
As the columns are autofiltered and the charts can react to any filtering or
sorting, that predicates quite an overhead when each new data element is
appended and a new "snapshot" taken. It's almost as if one can see the cogs
turning ;).
Thanks again.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210222/1c4db47b/attachment.htm>