Comments
-
Thanks for the response. I was hoping it would be possible in Magic but happy with SQL. In this case I just want to make the non-numeric data null.
-
I had exactly the same problem except mine broke at 11am as I'm UTC +11. When you use now() it returns the time in UTC but the card is in the timezone set in Admin. I used addtime to bring the Beast Mode into my timezone by adding 11 hours. So instead of using now() I use this: ADDTIME(NOW(),39600)) However, it doesn't…
-
Hi Austn, thanks for replying but it isn't a big deal for us. I was just curious if I'd missed something in the UI to reset colour rules.
-
I got one of our SQL guys to handle it, but looking at the structure of the data from Facebook Ads again, it might be possible to use an uncollapse columns tranform in Magic ETL? I haven't tried this.
-
Works perfectly - thanks!
-
I worked this out. It was because I had included some mobile only dimensions. Limiting the dimensions for these I see metrics for desktop, tablet and mobile. * Time* Date * Platform or Device* Device Category * Operating System
