Difference between revisions of "Special"
(Created page with "The special columns consists of set of auxiliary columns that enable to add to the objects useful calculated columns. These formulas are available only in the object they wer...") |
|||
| Line 8: | Line 8: | ||
== Accumulated == | == Accumulated == | ||
| + | |||
| + | Calculate the accumulated value of the value selected in the [[Reference column]] column property. The column value is calculated by adding the current row value plus all previous rows values. | ||
== Expression == | == Expression == | ||
| + | Allows to create custom expressions and formulas for he column. See [[Expressions]] for more information on how to create it. | ||
| − | |||
== Individual Participation == | == Individual Participation == | ||
| + | |||
| + | Calculate the individual participation of the value of the current row in relation to the others, displaying the percentage of how much the row represents compared to the total amount. The value calculated is the selected in the column [[Reference column]] property. | ||
== Percentage Variation == | == Percentage Variation == | ||
| + | |||
| + | Calculate the variation of the value of the current row in relation to the previous row, displaying the percentage of how much the row variates. The value calculated is the selected in the column [[Reference column]] property. | ||
Revision as of 14:32, 24 May 2013
The special columns consists of set of auxiliary columns that enable to add to the objects useful calculated columns.
These formulas are available only in the object they were created. For data source level formulas, that are straight available to any dashboard, see File Formulas.
Accumulated
Calculate the accumulated value of the value selected in the Reference column column property. The column value is calculated by adding the current row value plus all previous rows values.
Expression
Allows to create custom expressions and formulas for he column. See Expressions for more information on how to create it.
Individual Participation
Calculate the individual participation of the value of the current row in relation to the others, displaying the percentage of how much the row represents compared to the total amount. The value calculated is the selected in the column Reference column property.
Percentage Variation
Calculate the variation of the value of the current row in relation to the previous row, displaying the percentage of how much the row variates. The value calculated is the selected in the column Reference column property.
Example
