1,438
edits
Changes
Marked this version for translation
<!--T:69-->
You can create expressions (formulas) directly in the dashboard components. It can thus display calculated values that are not present in the data source datasource file/spreadsheet.
We just remember that currently TaticView only supports expressions whose numeric return.
<!--T:225-->
Expressions support the backslash as [[EscapeChar|escape character]] so that names can contain the delimiting characters.
<!--T:76-->
== Basic structure of a Expression (Formula) == <!--T:77-->
==== Identifier ==== <!--T:226-->
<!--T:227-->
It is the name of the field or column involved in the expression, it must be delimited by double quotes.
<!--T:228-->
* Examples: "Average Price". "Screw 1\" philips", "Seler"
==== Value Operand ==== <!--T:78-->
<!--T:95-->
* Example: IF("Product" == "#null";0;20)
== Arithmetic Expressions == <!--T:96-->
'''BETWEEN("Date Issued"; '01/01/2019'; '31/12/2019')''' - Returns true if ''Date Issued'' is between ''01/01/2019'' and ''12/31/2019''. Otherwise returns false
==== COUNT function ==== <!--T:229-->
<!--T:230-->
Returns number of occurrences (lines) for column or value.
<!--T:231-->
By now this functions works only at Datasource expressions
<!--T:232-->
Syntax:
COUNT(<expression>)
Example:
'''COUNT("Product")''' - Returns number of occurrences (lines) of products
==== COUNT_DISTINCT function ==== <!--T:233-->
<!--T:234-->
Returns number of unique occurrences (lines) for column or value.
<!--T:235-->
By now this functions works only at Datasource expressions
<!--T:236-->
Syntax:
COUNT_DISTINCT(<expression>)
Example:
'''COUNT_DISTINCT("Product")''' - Returns number of unique (different) occurrences (lines) of products
==== IF ELSE function (If .... Otherwise ...) ==== <!--T:153-->
<!--T:224-->
Syntax:
ROUND(<value>;<precision>)
Example:
'''ROUND("Profit")''' - If Profit 10.38 returns 10.00
'''ROUND(15.65)''' - Returns 16.00
'''ROUND(1.777;1)''' - Returns 1.8
==== SQRT function (Square Root) ==== <!--T:174-->
* '''"@avg[column]"''' - Average column, similar to ''"@sum[column]"'' / ''"@count"''
* '''"@prev[column]"''' - Row value before current row for this column
* '''"@totalRowValue[column]"''' - Value of total row, (if present), from this column.
* '''"@accumCol[column]"''' - Cumulative value from column to current row. Useful for calculating variable mean.
** Example: ''"@accumCol[column]"'' / ''"@row"''
</translate>
