Discussions
-
Variables as Checkbox - Unimplemented Error
Hi All, Love these forums! Anyways. I created a beast mode calculation that takes into consideration my Campaign Metrics variable values. CASE WHEN Campaign Metrics = 'A' THEN (…) WHEN Campaign Metrics = B THEN (…) ETC… If I try to change the variable's control type [from a dropdown] into a checkbox selector [which allows…
-
Average of a calculated field that divides two columns
Hi, I have a calculated field that divides two columns for each row. We can call this calculated field 'row total' : SUM(`Total A`) / NULLIF(SUM(`Total B`),0) I am trying to get the overall average of all the Row Totals: avg(NULLIF(`Total Views`, 0) / NULLIF(`Total Conversions`,0)) I have been checking the dataset and…