Comments
-
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! :)