-
How to reset colour rules saved to a dataset?
We have a situation where some colour rules have been saved to a dataset (ie. apply to all cards) and now want to remove the rules, however can't find a way to do so. The user deleted the card and recreated it so we can't reset the colour rules. As a workaround we set up a beast mode which returns the required values and…
-
How to report on Facebook Ad metrics by campaign?
I'm new to Facebook metrics and am trying to work out how to configure the Facebook Ads connector to bring in metrics per campaign. I'm very familiar with Google Analytics, but Facebook is completely different. I've been trying the Insights report but I haven't found a way to have the campaign name as a dimension with it's…
-
Dealing with column types & bad data
Here's the problem I've come across a few times now: A CSV upload file has a column which looks like integers for the first hundred or so rows, but lurking further down are alpha characters. When creating a transform in magic, it loads the first 100 rows, sees they're all integers and sets the column type as such. Then,…
-
How to exclude current month from a card
I'm creating some cards to report on metrics for last month and some of those are a vertical bar chart for the previous 12 months. I want to exclude data for this month as it's incomplete and irrelevant. When filtering by date I can only exclude by picking a specific date, not relative such as "this month". I also tried…
-
Google Analytics Advanced connector - can't get desktop device metrics
I'm trying to create a simple pie chart to show the split of sessions by desktop/mobile/tablet. In GA the dimension is "device category", but when I bring this dimension into Domo it only has mobile and tablet. The figures for mobile and tablet match what I see in GA so I'm on the right track, but no desktop metrics. The…
