Summary: | CALC CHART Trend Lines for moving average not being "smoothed" similarly to Polynomial Trend Lines | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | Colin <that.man.colin> |
Component: | Chart | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | UNCONFIRMED --- | ||
Severity: | trivial | CC: | lou |
Priority: | medium | ||
Version: | 7.0.4.2 release | ||
Hardware: | All | ||
OS: | Windows (All) | ||
Whiteboard: | |||
Crash report or crash signature: | Regression By: | ||
Bug Depends on: | |||
Bug Blocks: | 116700 | ||
Attachments: | simple ,ods with chart & trend line function |
Description
Colin
2021-01-23 08:46:42 UTC
Created attachment 169105 [details]
simple ,ods with chart & trend line function
Actually none of the trend lines are smoothed but they look smooth because they are transformed into an approximated function, which is then sampled for drawing. That's not the case for moving average, which is different kind of transform, which results in averages of input values, not a function. So the question is if we should allow to also "smooth" that line or not. For example Excel doesn't - you can smooth a data line, but not a trend line. >
> So the question is if we should allow to also "smooth" that line or not. For
> example Excel doesn't - you can smooth a data line, but not a trend line.
If asked, I would observe that not smoothing the line gives a slightly less professional look.
No, I don't line all my fish sticks up on the plate 😉
(In reply to Colin from comment #3) > > > > So the question is if we should allow to also "smooth" that line or not. For > > example Excel doesn't - you can smooth a data line, but not a trend line. > > If asked, I would observe that not smoothing the line gives a slightly less > professional look. > > No, I don't line all my fish sticks up on the plate 😉 I would also observe that we do lots of things better than Excel - try sorting an auto filtered array with non-array cells referencing that array. Sometimes you're lucky. If we can be better and still not shoot ourselves in the foot when it comes to exporting to xlsx I would argue that it's worth the effort if it's not too onerous a task and we have the resources. 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. (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. |