transformations:shiftcolumn
no way to compare when less than two revisions
Differences
This shows you the differences between two versions of the page.
| Next revision | |||
| — | transformations:shiftcolumn [2018/05/23 22:52] – created dmitry | ||
|---|---|---|---|
| Line 1: | Line 1: | ||
| + | ===== Shift column ===== | ||
| + | |||
| + | This action shifts values in specified column up or down. When a column is shifted down, empty cells are inserted at the top of the column. When shifted up, empty cells are inserted at the bottom. | ||
| + | |||
| + | ===Use cases=== | ||
| + | This action can be used in cases when a comparison with a previous/ | ||
| + | |||
| + | ===Example=== | ||
| + | Source data: sales by year. | ||
| + | ^ Year ^ Sales ^ | ||
| + | | 2010 | 10000| | ||
| + | | 2011 | 12100| | ||
| + | | 2012 | 9000| | ||
| + | | 2013 | 11000| | ||
| + | | 2014 | 8500| | ||
| + | | 2015 | 11300| | ||
| + | |||
| + | Objective: Calculate the delta with previous year. For this, we're appending a new column which is column [Sales] shifted down by 1 row. | ||
| + | |||
| + | Result: | ||
| + | ^ Year ^ Sales ^ Prev. year sales ^ | ||
| + | | 2010 | 10000| | ||
| + | | 2011 | 12100| | ||
| + | | 2012 | | ||
| + | | 2013 | 11000| | ||
| + | | 2014 | | ||
| + | | 2015 | 11300| | ||
| + | |||
transformations/shiftcolumn.txt · Last modified: 2021/07/19 02:18 by craigt