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