GrantSmith Coach

It depends on how your data is structure and how you represent if there's data in the field or not but assuming you have NULL if the data is missing you could do something like this in a Beast Mode (assuming you're graphing on a quarterly basis): CASE WHEN MAX(`Data`) IS NULL THEN `Sum` + 2 ELSE `Sum` + 1 END It gets a bit…

Does it need to be done in Python? You can do this with a simple LENGTH function call either in SQL or via a Beast Mode: LENGTH(`Column Name`)

It's displaying blanks because you likely have nulls in your field you're calculating. You can fix that issue by utilizing IFNULL in your BeastMode `To Skill` / SUM(IFNULL(`To Skill`, 0)) With that being said this still won't answer your initial request. This is because the assumption was that the totals were calculated…

You can utilize the Rank & Window widget in a Magic ETL dataflow. Just select the row number function from the list and specify which column to order by.

I reached out to my Domo rep on this issue and they said it's a known issue they're working through with Google but don't have an ETA yet. They did suggest the Google Analytics Enterprise connector if you needed an immediate resolution.

You should be able to do a Beast Mode calculation: `Column 2` / SUM(`Column 2`) This will get you the percentage breakdown across the entire dataset. (Make sure it's formatted as a % in your card) Assuming this is your data: | Column A | Column 2 | Percentage | | ------------- | ------------- | ---------------- | | Cat 1 |…

Have you looked into any of the Writeback cloud connectors? There's several different options out there (most are an extra fee) but you can write back to google sheets for example.

If you're wanting to remove those rows you should use the filter option on your card to ignore records where the value is null. If you want to leave it in and give it a default value instead you could use a beast mode like: CASE WHEN `NonDirectionalCityPair` IS NOT NULL THEN `NonDirectionalCityPair` ELSE 'DEFAULT VALUE'…

Within beast mode this isn't possible because you can only do a single group level. Do display the single values and then get the sum of those values would require two separate grouping levels (individual values and entire dataset level). It's possible with a subquery in SQL but not possible in a beast mode.

One possible work around is to add a prefix character (not a number) to your invoice number and then have Domo strip out the prefix in a data flow after you've imported your file.

I've gotten around this issue and timing issues in the past utilizing a python script to pull the data out of Google Ads / AdWords via their API and pushing it into Domo using the Domo API and then just scheduling my script to run on a daily basis. Currently the API doesn't allow you to append to an existing API dataset -…

This ended up being an issue with ChannelAdvisor - They needed to approve the API connection on their end.

Nothing is showing up in the list because the different profile / account names haven't been authorized for your developer key. You'll need to follow ChannelAdvisor's API documentation on how to issue a SOAP request to attach a profile / account name to your developer key.…