Skip to main content

Formula Metric Builder

Formula metrics allow you to perform calculations on existing metrics, making it easier to answer complex analytical questions. They derive their values from other metrics, using them as variables in an equation. The Formula Metric Builder requires the following inputs:

Getting started

  • Name - The unique and descriptive name for the metric.

  • Entity - The entity for which the metric is being calculated.

  • Formula - The actual calculation of the metric using existing metrics, mathematical operations, and SQL. For example: $metric__bookings / $metric__bookings_count.

Advanced mode

For users comfortable with technical syntax, the Advanced mode allows you to create and edit metrics directly in SQL using our Metric Layer syntax. Toggle the "Advanced" option to enable this feature. This mode is beneficial for those who prefer working in a pure SQL environment and provides additional flexibility.

For more information on editing Formula metrics using SQL, check out the Formula Metrics documentation.