User Tools

Site Tools


advanced_transformations:creating_custom_metrics

How to format timestamps in charts

If you want to create an own metric you can do so with the following steps:

1. Click on explore data on any chart

2. Click on edit data set

3. Create the formula and add the formula for the metric

In this case we are summing up all conversions (markov) from types where the column type (conversion name) ends with install. More information on pattern matching in SQL

SUM(CASE WHEN type like '%install' THEN markov END)

Alternatively a cost per install would be calculated as follows:

SUM(totalcost)/COUNT(DISTINCT type)/NULLIF(SUM(CASE WHEN type like '%install' THEN markov END),0)

Then click save

4. Use the formula in your charts

advanced_transformations/creating_custom_metrics.txt · Last modified: 2022/10/25 13:54 by windsor_ai