What is VIVIDAVG?
The average of values from a select field of ServiceNow records
Syntax
VIVIDAVG(SN Table, Encoded Query, Field)
What are the different parameters required by the function?
SN Table - The system name for a table.
Encoded Query - The output of the condition builder in ServiceNow. This is used to filter down records on the defined ServiceNow table.
Field - The system name for a table on the already-defined table
Sample Usage
=VIVIDSAVG(pm_project, active=true, cost)
Notes about this function
There can only be one table defined in this function.
To get the encoded query, write it directly into the function bar, or go to a ServiceNow table, use the condition builder, copy the encoded query, then past it into the VividSheets function bar.