Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision |
transformations:start [2021/07/08 16:57] – [Import / App & Cloud] dmitry | transformations:start [2021/07/08 17:08] – [Transform / Math] dmitry |
---|
| |
==== Transform / Math ==== | ==== Transform / Math ==== |
| * [[transformations:distributetotal|Distribute total]] - Break down a total/subtotal proportionally to a group of numbers (weights). |
* [[transformations:linearregression|Linear regression]] - Build a linear regression. Interpolate/extrapolate values if needed. | * [[transformations:linearregression|Linear regression]] - Build a linear regression. Interpolate/extrapolate values if needed. |
* [[transformations:statisticalaggregation|Statistical aggregation]] - Calculate median, percentile, standard error, standard deviation, or variance. | |
* [[transformations:runningtotal|Running total]] - Calculate rank, cumulative count, sum or % from total sum. | * [[transformations:runningtotal|Running total]] - Calculate rank, cumulative count, sum or % from total sum. |
| * [[transformations:statisticalaggregation|Statistical aggregation]] - Calculate median, percentile, standard error, standard deviation, or variance. |
* [[transformations:subtotal|Total/subtotals]] - add column total or group subtotals as a new column. | * [[transformations:subtotal|Total/subtotals]] - add column total or group subtotals as a new column. |
| |