getFormula
Last updated
Was this helpful?
Last updated
Was this helpful?
A Formula model is a data model that represents a single numerical statistic, such as an average or a count. Suitable for headline or scorecard type of visualizations.
The getFormula
model inherits all options from the , plus:
column: the name of the column that you will run the statistical operation on. It also accepts the *
value, that will
name of the column
*
for total row count , used with count in operation
empty string, in combination with custom + operationExp
operation: the statistical operation that will be performed on the column. Accepted values are:
count
avg
min
max
sum
custom
: a custom SQL expression, specified by operationExp
.
operationExp (optional): when using operation: 'custom'
you need to specify the exact SQL operation that you want to run on your column. For example: AVG(column_A) / AVG(column_B) * 100
.
A simple object containing the numerical value of the widget:
The response can be then mapped to any HTML element, such as a scorecard.