Beast mode percentage of
I am trying to calculate the percentage of the total for each media. I will be using this on a table (media as dimention, spend as metrics). Here is my formula: SUM(CASE WHEN `media` = 'Radio' THEN `spend` WHEN `media` = 'A' THEN `spend` WHEN `media` = 'B' THEN `spend` WHEN `media` = 'C' THEN `spend` END) / SUM(`spend`)…
