Changes

Jump to: navigation, search

Expressions/en

583 bytes added, 02:26, 5 October 2022
Updating to match new version of source page
<div class="index-right">__TOC__</div>
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.
'''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 ====
 
Returns number of occurrences (lines) for column or value.
 
By now this functions works only at Datasource expressions
 
Syntax:
COUNT(<expression>)
Example:
'''COUNT("Product")''' - Returns number of occurrences (lines) of products
 
==== COUNT_DISTINCT function ====
 
Returns number of unique occurrences (lines) for column or value.
 
By now this functions works only at Datasource expressions
 
Syntax:
COUNT_DISTINCT(<expression>)
Example:
'''COUNT_DISTINCT("Product")''' - Returns number of unique (different) occurrences (lines) of products
==== IF ELSE function (If .... Otherwise ...) ====
11,677
edits

Navigation menu