Formulas is a visual formula builder to construct mathematical formulas using the data points and their properties as variables and filters letting you construct new KPIs and metrics without having to track additional data points or needing to do the calculations outside of Countly. You can visualize your formulas within the Formulas view itself or via Dashboards.
Some select examples of formulas you can build include:
- Percentage of users in one or more cohorts, compared to overall users or other cohorts. For a telehealth application, there can be a cohort for each of the main medical specialties and you can create a formula for a specialty like pediatrics to see how the number of users getting help about the topic in the last 30 days compares to the overall users who had an appointment within the same period.
- Per-user average, such as finding the per-user average of the sum property of an Event X. For a navigation application, event Journey might include “kilometers driven” stored as the sum property of the event, and using formulas you can easily find out what is the average kilometers driven by users who completed a journey.
- Combined count of multiple events or combined filtered occurrences of events. For a banking application with an event to capture credit card applications and another one to capture loan applications, you can report total applications from “Premier” customers for both loans and credit cards.
- Conversion rate using the start and end events (or views) of a conversion funnel. For a SaaS application, you might be taking advantage of automatic view tracking and then you might have an event for when the user completes an account upgrade. Using formulas you can calculate the percentage of these users over users who have viewed the pricing page.
You can reach the full feature specifications of this feature from our User Guide documentation: