s_f_OTT Member

@rco @ArborRose Thank you both for your help. Ultimately, I realized that I could just export the smaller dataset I needed to excel, make the transformation I needed and reupload making sure to filter out any data that could have been duplicated.

There are probably 5 rows that all say the same campaign name. Each row has thousands of impressions that total up to some number, say a million. I have to split it up because of the way the data was sent to us.

Is there a way to take 1 one of data and split it into 3 rows of data?

I am not really following this; this isn't probabilities though.

Sorry for the confusion. Lets say I have a million impressions in Campaign 1. I am looking to say take 40% of those and call it NHL, take another 40% and call it NBA, and take the last 20% and call it NCAAF. In MOST other campaigns, I can say CASE WHEN Campaign LIKE NHL then NHL. But this campaign does not have that…

Where do I find these example DDX bricks?

Thanks everyone!!! Fuzzy_parse_date worked perfectly!

@MichelleH Unfortunately, that did not work either. Should I split the numbers apart then put them back together?

I have checked through my dataset and there is nothing that starts with a '/'

In your formula, are you doing something like FIXED (BY Month('date')) ? If so, you do not need the MONTH formula. I have found it works well with fixing by the date and gives me the flexibility you are looking for.

I know what the issue is. The eCPM is calculated on based on rows labeled GAM and therefore the eCPM only shows in GAM rows and SS Rows are then left blank for eCPM. I need the eCPM to show in ALL rows. The calculation for eCPM is (SUM(CASE WHEN Ad Server = 'GAM' THEN Revenue END) / SUM(CASE WHEN Ad Server = 'GAM' THEN…