-
Unique calculation
I have an issue where there is a campaign "Campaign 1" that needs to be split out into 3 parts; NHL, NBA, and NCAAF. NHL will get 40% of the impressions, NBA will get 40%, and NCAAF will get 20%. I cannot figure out how to break this into 3 parts and calculate the impressions. I have multiple other campaigns that I can…
-
Rank and Window Function - SUM
I am trying to create a SUM in a Rank and Window ETL Tile. I have no reason to put a Frame Range in other than unbounded but it will not let me APPLY. I must be doing something wrong. Should the FOLLOWING box be a 0?
-
Error with String to Date
I am having an issue with a column that looks like a date but for some reason will not convert to a date. I am trying to use String to Date but it keeps giving me an error. Any ideas?
-
Calculated field for before and after date
I have a calculation based on date that is only half working. CASE WHEN (DATE(Date)<'03/01/2024') THEN SS Revenue ELSE (SS Impressions*eCPM/1000) end In the formula, it is pulling in the correct amount when it is BEFORE 3/1/2024, but for some reason, it is returning 0 for anything after that date. When I look at the SS…
