GrantSmith Coach

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.…