Comments
-
I tried testing the formula as suggested but it's not working on my end, any idea of another potential workaround?
-
This is helpful, thank you! Is there any way to include it in the Select portion? Similar to the following: SELECT *, 'YouTube' as Platform, "MONTH" as "Date" , sum("ESTIMATED_YOUTUBE_AD_REVENUE")/(sum("AD_IMPRESSIONS")/1000)NOTNULL as "CPM" from "youtube_monthly"
-
Following up : The only filter showing up is Facebook although there is data across all the other social platforms. To add some context, all the columns are set as dimensions, so we want any dimension (column) that includes the word Facebook to be filtered as "Facebook", all that include the word "Twitter" to be filtered…
-
Thank you so much! I will attempt to build this formula and follow-up if it works! Greatly appreciate the support!
-
Hi @MarkSnodgrass Amazing, it worked! Thank you!
-
Hi @MarkSnodgrass thank you! I tested the code you provided but it doesn't match with the data I ran with the initial code shared. Any way I can use the original code but with the proper syntax? CASE When DATEDIFF("date","published_date") >0 and DATEDIFF("date","published_date") <=29 then '01 Month' when…
-
Hi there, Day or Month were not recognized parameters in the syntax. Greatly would appreciate to hear any additional alternatives I could take, thank you!
-
Hi @GrantSmith, inspired by the beastmode you shared, any feedback on my beastmode? Basically trying to say when the overall general revenue is greater than 1000 and month 12 revenue is less than 100 then 'XYZ' CASE WHEN revenue> 1000 AND (DATEDIFF(date,published_date) >329 AND DATEDIFF(date,published_date) <=359) < 100…
-
Thank you @GrantSmith! I will actually be testing this beastmode today! :)
