Quick links
Getting data into other tools
Advanced features
Advanced transformations
Datasource specific
Quick links
Getting data into other tools
Advanced features
Advanced transformations
Datasource specific
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