DamienSmith

+1 we also need this functionality. 

I've just come across the same problem with emailing table cards. I can understand limiting the rows but to have a hard limit of displaying only 3 columns in the emailed report is very frustrating. We have a simple table which we want to email to a group of social users. They have no other reason to log into Domo and just…

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

Domo support confirmed that there isn't a metric in the GA API for returning users so I did some digging to work out how to calculate the metric. Bottom line is that reporting on total or returning users for any time period greater than 1 day won't be accurate when compared to GA. GA shows the number of unique users for…