Tips and tricks: When to use custom and aggregate formulas in Analytics Plus
If you want to define your own formulas to meet your reporting requirements, you can make use of the custom and aggregate formulas in Analytics Plus.
Custom formulas
can be used to get derived values from your raw data, more specifically for string and data columns, while a
ggregate formulas
are useful for aggregating numeric data and deriving statistical values. They are useful when you want statistical output like average, mean, median etc.
An example for custom formula: This formula calculates the assignment time (in hours) of each request in the helpdesk.
An example for aggregate formula: This formula calculates the percentage of overall requests that have been escalated.
Click here to know more about adding formulas.