Computes median or average or sum of a column. Each cell value in the column is expressed in percentage.
This operation can only be performed for columns with numeric values.
| Basis = sum of entire column | Basis = column average | Basis = column median |
---|
Operation setting |
- First, the sum of the column is computed = 44
- Then, each individual value is expressed as percentage of this basis. e.g. 10/44 = 0.227..
|
- First, the average of the column is computed = 44 / 5 = 8.8
- Then, each individual value is expressed as percentage of this basis. e.g. 10/8,8 = 1.13636
|
- First, the median of the column is computed = 7
- Then, each individual value is expressed as percentage of this basis. e.g. 10/7 = 1.42857
|
Result | | | |
TIS Project | Confluence Op As a percentage.gzip |
Nothing known up to now.