User Tools

Site Tools


advanced_transformations:creating_custom_metrics

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

advanced_transformations:creating_custom_metrics [2022/10/25 13:53]
windsor_ai created
advanced_transformations:creating_custom_metrics [2022/10/25 13:54] (current)
windsor_ai
Line 19: Line 19:
 Alternatively a cost per install would be calculated as follows: Alternatively a cost per install would be calculated as follows:
  
-<code>SUM(totalcost)/COUNT(DISTINCT type)/NULLIF(SUM(CASE WHEN type like '%install' THEN markov END),0)<code>+<code>SUM(totalcost)/COUNT(DISTINCT type)/NULLIF(SUM(CASE WHEN type like '%install' THEN markov END),0)</code>
  
 {{:advanced_transformations:custom_metrics_3.png?600|}} {{:advanced_transformations:custom_metrics_3.png?600|}}
advanced_transformations/creating_custom_metrics.1666702431.txt.gz ยท Last modified: 2022/10/25 13:53 by windsor_ai