The Calculator allows you to create calculations using events and/or arbitrary numbers. It can be accessed through the calculator icon, located in the lower righthand corner of the query builder.

The Calculator Modal

The Calculator modal consists of a list of your query rows, five mathematical operations, and two drop zones. Using the calculator, you may add, subtract, divide or multiply any two query rows. You may also choose to view the results of your calculation as a percentage, by selecting the percentage operation in the operation drop down menu. Calculations appear in the query builder as new rows. You may click on a calculation query row to edit the calculation.

Calculating with Events

The Calculator modal contains each row of your query. Query rows may contain a single event or a combination of events, event properties, and user properties. Drag and drop two rows into the top and bottom drop zones, then select an operation to use.

For example, if you want to find how well an email campaign is converting into free trial starts, add both the “Email Link Clicked” and “Free Trial Start” events to the query builder. Then, open the Calculator tool and set “Free Trial Start” as your numerator and “Email Link Clicked” as your denominator.  

Calculations are visualized in the chart area, alongside the underlying queries. To view the calculation independently, go into the query builder and use the "Hide in Results" button to hide components of the visualization. This will not delete the components, only hide them from view. 


Calculating with Numbers

Using arbitrary numbers in a calculation gives you the ability to scale datasets, calculate averages when looking at aggregate charts, or use absolute numbers to create a metric directly on the chart. Click on the top or bottom drop zone and type in a number to create numerical calculations.

For example, if you need to calculate the annualized churn rate per week of your subscribers, open the calculator, then take the weekly subscription stops and multiply it by "52". 


Nested Calculations

You can create nested calculations by using an existing calculation in a new calculation. Find the row containing the original calculation, and drag it into the numerator or denominator position to nest it within a new calculation.

1 users found this helpful