Query editor
SELECTsum(lost_usd_30d_before) AS lost_usd_all_removals,sum(IF(outcome NOT LIKE '1 %', lost_usd_30d_before)) AS lost_usd_excl_readded,sum(IF(outcome LIKE '3 %', lost_usd_30d_before)) AS lost_usd_switched_away,count(*) AS routes_removed_180d,count_if(lost_usd_30d_before > 0) AS routes_with_lost_volume,count(DISTINCT oapp) AS apps_removing_180dFROM query_8958350