Create custom calculated metrics for your workspace in the Metrics tab of your Workspace Settings page. Simply click "Add New Metric" to get started.
The "Calculation" field supports standard arithmetic operators (addition, subtraction, division, multiplication) and basic aggregate functions.
In addition to the standard arithmetic operators, the following aggregation functions are available:
.sum( $variable )
.countDistinct( $variable )
.filter( boolean_expression )
.average( $variable )
Functions can be chained. For example, let's say you have a set of event records that includes purchase events. To count the number of distinct users who have completed purchase events using cash, you would use:
$main.filter($event == 'PURCHASE' and $payment == 'CASH').countDistinct($user_id)
Here's a cheat sheet with some common metrics we see in workspaces. Copy what works for you (making sure to replace all
$variables with your respective column names) or just use these as a jumping off point.
Count of all records
OK Response rate
Is open auction rate
Updated 5 months ago