Difference between revisions of "Special"

From TaticView
Jump to: navigation, search
 
(3 intermediate revisions by 2 users not shown)
Line 1: Line 1:
The special columns consists of a set of auxiliary columns that enable to add to the objects useful calculated columns.
+
<languages/>
  
These formulas are available only in the object they were created.
 
  
 +
<translate>
 +
<!--T:1-->
 +
The special columns consist of a set of auxiliary columns that enable to add to the objects useful calculated columns.
 +
 +
<!--T:2-->
 +
These formulas are available only on the object they were created.
 +
 +
<!--T:3-->
 
Special columns can not be used in [[Cross Table]], [[Pie Chart]], [[Cross Column Chart]], [[Cross Bar Chart]], [[Cross Line Chart]], [[Cross Area Chart]] and [[Gauge]]  objects.
 
Special columns can not be used in [[Cross Table]], [[Pie Chart]], [[Cross Column Chart]], [[Cross Bar Chart]], [[Cross Line Chart]], [[Cross Area Chart]] and [[Gauge]]  objects.
  
  
 +
<!--T:4-->
 
__TOC__
 
__TOC__
  
  
== Accumulated ==
+
== Accumulated == <!--T:5-->
  
 +
<!--T:6-->
 
Calculate the accumulated value of the value selected in the [[Reference column]] property. The column value is calculated by adding the current row value plus all previous rows values.
 
Calculate the accumulated value of the value selected in the [[Reference column]] property. The column value is calculated by adding the current row value plus all previous rows values.
  
  
== Expression ==
+
== Expression == <!--T:7-->
  
 +
<!--T:8-->
 
Allows to create custom expressions and formulas for the column. See [[Expressions]] for more information on how to create it.
 
Allows to create custom expressions and formulas for the column. See [[Expressions]] for more information on how to create it.
  
  
== Individual Participation ==
+
== Individual Participation == <!--T:9-->
  
 +
<!--T:10-->
 
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.
 
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 == <!--T:11-->
  
 +
<!--T:12-->
 
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.
 
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 ==
+
== Example == <!--T:13-->
  
  
 +
<!--T:14-->
 
[[File:special_columns.png|link=]]
 
[[File:special_columns.png|link=]]
  
 +
<!--T:15-->
 
The above example, shows a month chronological analysis by an expression (Gross Sale - Cost), and the accumulated, individual participation and monthly percentage variation of Costs.
 
The above example, shows a month chronological analysis by an expression (Gross Sale - Cost), and the accumulated, individual participation and monthly percentage variation of Costs.
 +
</translate>

Latest revision as of 12:54, 19 September 2017

Other languages:
English • ‎português do Brasil


The special columns consist of a set of auxiliary columns that enable to add to the objects useful calculated columns.

These formulas are available only on the object they were created.

Special columns can not be used in Cross Table, Pie Chart, Cross Column Chart, Cross Bar Chart, Cross Line Chart, Cross Area Chart and Gauge objects.



Accumulated

Calculate the accumulated value of the value selected in the Reference 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 the 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

Special columns.png

The above example, shows a month chronological analysis by an expression (Gross Sale - Cost), and the accumulated, individual participation and monthly percentage variation of Costs.