GrantSmith Coach

There isn't a dataset currently containing the email for you to search. You'd need to search through each connector configuration for the email address. I'd recommend adding this as an idea to the idea exchange to enhance the email connector.

It's hard to say what's going on in the back end. If you right-click on the webpage you can select Inspect from the drop down Then you can select the Network tab, select Fetch/XHR from the top and see if any of them are red. You can then select one to see what the error may be. Does your filter card load if you limit it to…

If you want the connector to add additional endpoints or datasets, you'll need to contact Domo Support, as they control the source code for that connector and would need to make the changes for you. Alternatively you can create your own custom connector and self-publish to connect to the endpoints you want a bit faster…

I'd recommend you split out each of your case statements into their own beast mode so you have just the formatting logic in each to see how each one applies to your data. This will help identify if there's an issue with your specific individual clauses or the entire beast mode.

Can share means they can share it with other users. Can edit means they can change the settings and scheduling of the dataset. In order to edit the dataset, you'll need access to all the rows, which is why you're seeing that.

There isn't a connector that's been created for recruiter data. You'd need to create your own. Domo does have documentation on this in their developer portal here:

Ah. You can't dynamically change the format in the formatting options but you'd have to do it within a beast mode which can be a bit complex. You can use something like this to get you started with numbers or currency formatting:

To clarify, the company timezone is what the UI will display your timestamps with and will convert the values when the data is displayed. Domo assumes UTC for all data being imported.

You can't change the title of a field on your cart with a variable. It's set to whatever you define it when in analyzer. You'd have to use a generic name like Metric or something.

I'd agree. Have two separate cards, one for the line + bar and the other for an HTML table where you can have up and down color-coded arrows. Here's a post I did talking about architecting your data for PoP comparisons, which gives you more flexibility: And here's another post about how to do custom colorization within a…

You can use the LAG function to calculate prior row values. Here's a previous post I did talking about LAG and doing a rolling average:

I've written up a post about this previously here: It will go over the beast mode and have a video on it as well.

You can use the domo.navigate function to go to a different URL: Known Limitation Regular HTML link syntax will not work in Domo Apps. Use the domo.navigate javascript function below to create a link. As for your images, are they included within your app? Have you inspected the network traffic to see if the images are able…

You use the SQL format for comments which is two dashes -- in place of a hash #

If you inspect the network traffic, are there any errors occurring? Typically, Domo has a timeout of 60 seconds, so if it can't get your data within 60 seconds, it'll fail.

CASE WHEN `Date` >= CURRENT_DATE() - INTERVAL 6 DAYS AND `Date` <= CURRENT_DATE() THEN 'YES' ELSE 'NO' END This will check if your date is within today and 6 days ago (Tuesday - Monday using today as an example) You can tweak it if you want to look at 1-7 days ago.

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