GrantSmith Coach

You can either use your external architecture to run your python script and the pydomo package to upload the data into domo. Alternatively you can utilize a Domo Jupyter workspace or a Python Tile in to run your script entirely within Domo.

You can Magic ETL and combine your dataset with the Governance Datasets dataset based on your dataset ID to include the last updated at timestamp in your dataset and then reference it in your card.

You could do this with a customized Domo brick. Essentially, you want to do a more simplified form editor-type brick where instead of using a table and fields, you're just using a button to trigger the event to write your record and sync it with a Domo dataset. Here's a URL to the Form and Dataset Brick - just replace your…

Sure, we can chat. I'll send you a DM.

Have you considered using the JSON connector if their API returns JSON data? JSON No Code Connector JSON OAuth No Code Connector Alternatively, you can just create a custom connector to process the API data if you need additional cleaning/transformation. It's a bit more technical route but more flexible. Custom Connector A…

COUNT(CASE WHEN column name IS NULL THEN 'NULL' END) You can return a value (in this case the string 'NULL') when the column is null and return null; this will allow your COUNT to work.

It's not a simple code swap but requires a dropdown control instead of a textbox control. You'd need to read in all the values for your drop-down control and when the table is displayed set the dropdown to the current value. When you write the record you'd need to pull the value from the drop-down similar to how it's…

I'd start by talking to your Account Executive.

Domo CLI tool has a command called swap-ower which allows you to reassign different object types. swap-owner: Transfers ownership of Alerts, Cards, Groups, Pages, Reports, DataSets, and DataFlows from one user to another. This command changes ALL objects (of the specified type/s) which belong to a user. Note: -nt and -ot…

Currently no, I don't believe animated GIFs are supported.

Yes, I use pydomo for a lot of scripts and it works well. There are two update methods, data sets and streams. You can use streams to upload data in segments and finally commit the stream when it's done which are better for larger datasets. Overall yes, I'd recommend pydomo in your use case as it'll help streamline your…

The text box returns the first record it finds. Since your beast mode is returning just the ID in the ELSE clause you get the first ID. Remove the ELSE clause from your case statement and then filter your text card so that the value is not null.

You can use the Java CLI to 'get-certified-content' that includes both datasets and cards. From there, you would import that data as a new dataset and then join that data up with Domo Governance or DomoStats datasets.

You need the actual server host name and connection information as domo doesn’t know about your RDS configuration

Have you thought about splitting your metrics into different tables for visualization instead of putting in a blank line? As @MichelleH mentioned they only way is to add rows to your dataset

What do the raw numbers look like and what is the date they get translated to? I’m wondering if it’s assuming they’re Unix timestamps and you can convert them back to Numbers by using the TO_UNIXTIME function in a formula tile

Have you been able to look over the network traffic with the developer tools on Chrome? This will typically show you any connection or network errors that may prevent the iframe from loading correctly.

rdomo doesn't support defining the dataset's schema when you upload it. It attempts to determine the schema automatically. With your numbers it fails the first two checks where it's looking for a specific date format however the third check attempts to conver the number to a date which succeeds so it assumes it's a date.…

rdomo doesn't support defining the dataset's schema when you upload it. It attempts to determine the schema automatically. With your numbers it fails the first two checks where it's looking for a specific date format however the third check attempts to conver the number to a date which succeeds so it assumes it's a date.…

Awesome work @jessdoe !

Look into using FIXED functions in a beast mode with the FILTER NONE option to prevent filtering from being applied https://domo-support.domo.com/s/article/4408174643607?language=en_US

You’ll need a dataset with each metric and definition. You can then use a filter dropdown card to allow the selection of a specific metric. You can then use a table card to display the metric and definition after it’s been filtered

Domo has documentation on creating custom connectors in their developer portal. You can reference it here:

Do you have something in the data label box at the top of those settings? If it's blank it won't display anything, you can use a magic keyword to return the total and then show where you want it displayed on.

You can use the split columns tile in magic ETL or utilize a formula tile with a regexp_replace or split_part function depending on how your field is formatted. Do you have an example of what your data looks like?

Domo doesn't expose that information in the api.domo.com dataset endpoints. You could attempt to get the api call the dataset page is using and use that to get the data you need but it's a more technical route and it's supported by Domo.

Have you looked into utilizing color rules so that if it's < 0 it's green and > 0 it's red?

You can install other libraries in your workspaces. It's documented here:

You could use magic ETL and a regular expression to format your data and then split it. SPLIT_PART(REGEXP_REPLACE(`Parent Lead Source`, '([a-z])([A-Z])', '$1::$2'), '::', 1) This will find the occurrence where a lowercase letter precedes an uppercase character and then injects '::' between them to be able to split it apart…

There may be a beta available that could allow you to change ownership of accounts, but you'd need to speak to your CSM about it.