GrantSmith Coach

Do you know the values ahead of time you're looking to filter with or were those to be generated on the fly based on your dataset?

You can utilize the command line utility to export all of your Workbench data sources to a folder as JSON objects. 'C:\Program Files\Domo\Workbench\Wb.exe' export-jobs -s YOUR_DOMO_URL -o OUTPUT_FOLDER These JSON files will contain the last execution status under: dataset["WorkbenchConfig"]["LastExecution"]["Success"] This…

It allows all of your database connections and data pulling to be done on your local network rather than having Domo do it directly via the web UI. Some companies like this so there's only one point of ingestion into Domo instead of opening access to all of their local databases from a security standpoint. Here's some…

Have you tried using a form of the group by chart type? You can have one group be your actual and the other be your goal

You might also need to have a space inbetween the first { and the " ^{ *"value"\s*:\s*"(.*)",.*}$ This version would handle if there is a leading space or not.

In my raw dataset I've got a date field for each day of the year. That beastmode calculation allows me to use the date selector on the card to graph by day, week, month year etc and it will update % change for each timespan I'm looking at. Take these two screenshots of sample data: Daily ViewMonthly View I've got some…

I utilize SUM all the time to help determine the percent difference dynamically between two values. (SUM(`NewValue`) - SUM(`OldValue)) / SUM(`OldValue`) When I have data sliced on a daily basis this allows me to change the time slice to weekly / monthly / yearly etc and calculate the percentage difference.

@user022663 - Are you formatting the percentage correctly? If it's displaying a number and it's under 50% (0.5) it'll round down being displayed as 0. Make sure your field is being formatted as a percentage and check the multiply by 100 box (and even add a decimal point or two)

If you don't care about the folders then you can use the Replace Text widget with the following regular expression (and replace with the empty string). It will handle any number of folders. ^.*\\ See the attached screenshot for the configuration options.

One thing to look out for though is that converting the number to a text field will cause Domo to sort it based on the textual representation and not the numeric number within the field. For Example (text sorting): 1 10 2 3 ... 9 The way to get around the textual sorting issue would be to left pad your numbers with 0s…

You can utilize a two step regex in a Replace Text block. See the attached images on how it's done. This is under the assumption it's in the same order / format each time. It would be easier if Domo supported RegEx Match Groups so you could easily just utilize the number shortcuts for the groups it matches within…

Have you looked into the Ads Report with the Ad Creative Edge using the Facebook Ads Advanced Connector? It returns a field `thumbnail_url` which you can then utilize an HTML IMG tag using a BeastMode CONCAT('<IMG src="', `thumbnail_url`, "/>') Using this BeastMode in a table card will display the image.

You really can't do much without an internet connection. It's required to communicate and authenticate with your domo instance.

When interacting with Google Ads I've had to do it two separate ways (I didn't have access to BigQuery at the time). The first was writing a custom Python script to query the Google Ads API for the information I needed and then utilized the Domo API to upload that dataset into Domo. It's a very technical process and you'll…

A BeastMode calculation can allow you to convert your decimal (number of days I'm assuming here) to an HH:MM:SS format: CONCAT(ROUND(Sum(`Handle Time`)/Sum(`Handle Contacts`) * 24 - 0.5, 0), ':', ROUND((Sum(`Handle Time`)/Sum(`Handle Contacts`)*24 - ROUND(Sum(`Handle Time`)/Sum(`Handle Contacts`) * 24 - 0.5))*60-0.5, 0),…

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