ArborRose Coach

CONCAT(DIVIDE(`YourColumn`, 1000000000), ' BN')

Hours: DATEDIFF(timestamp2, timestamp1) * 24 Minutes: DATEDIFF(timestamp2, timestamp1) * 24 * 60 Seconds: DATEDIFF(timestamp2, timestamp1) * 24 * 60 * 60

Change the values from % to decimal. For example, instead of 21%, use the value .21 so Domo sees it as a measurement. Create a card and choose the "Line Chart" option. For the X-axis (categories), you'll want to select the Row Labels (good, bad, evil). For the Y-axis (values), you'll want to select each of the Plan columns…

Responding to @DataMaven….trying to explain as best I can recall. Users need to pay close attention to data structures and accuracy. If I retrieve a date, I don't want it converted to a string or a datetime value. I want a date. And I want an accurate date. When we first configured Domo, we needed to pull from a third…

I agree with Grant. You should check on the error to find out why you're getting the error. An alternate method - you can automate the download of the file from the SFTP site and then upload the file into Domo using Workbench.

I'll have to read up on @timehat's suggestion. I don't use the Views Explorer because I don't want it altering my ability to use standard tools as the warning says. That message always keeps me from exploring…bad pun intended. Michelle is absolutely right about speed. Domo's implementation of SQL is horrendous. I too am…

While I have our instance set at UTC, I hate it. Domo treats API data as UTC. But the APIs I connect to are not UTC, they are in the proper US time zone. We worked tirelessly with Domo and couldn't get a solution working. Domo can't handle it unless we keep our domain set six hours ahead. That means I have to deal with…

Can you hold down the control key to open a card in a new tab? Unfortunately, if they made that a default…it would be the reverse for all us who do not want new windows opened.

Good job David.

@mmisky87 - I'm not much of a Python programmer btw. The method I use to export is quite easy. Install Python on the computer. Schedule a task that executes a small piece of python code (text file). In the code, the dataset identifier is given, and the export file path and name. Happy to share the code if needed.

I'm not sure exactly what you are asking. You can easily import an Excel file into Domo through the file upload. Or use Domo Workbench to schedule an upload/update to a Domo dataset. I'm not sure all the ways to extract. I use Python to extract a dataset out to Excel. Using this method, you can bring large datasets…

@DataMaven - Yes, I'd like to manage the schedules. But first, get an accurate account of what is scheduled. One of the problems with using the history, is that it shows what ran, not schedule settings. I see Domo running things far off the time I have set. I'm interested to see what you come up with in your Gantt view. If…

I haven't found Domo to be very flexible in creating cards with different borders or colors. I don't know a simple way to do this, but you could try it with a some kind of html chart that uses CSS. /* Default text color */ .myValue { color: green; } /* Text color when condition is met */ .myValue { color: red; }

On the recursive ETL, you can set the schedule that triggers. The timestamp formula you use will dictate what gets saved. I use a formula that runs on Monday on one my recursions, that gathers from the previous Sunday through the previous Saturday.

Let me first state how excited I am that someone is looking at this. Imagine the company manages stores. We don't, but pretend we do. All the stores have sales transactions each night. And those transactions are customer purchases. Every night you need to pull all the data from the stores and centralize the data. To…

using: CASE WHEN SUM(CASE WHEN `Product`='c' THEN 1 ELSE 0 END) OVER (PARTITION BY `ID`) > 0 THEN 1 ELSE 0 END

A few suggestions… Maybe check the connector to make sure you aren't filtering the data to only include your own tickets. Check query parameters to make sure there's nothing limiting the data retrieved. Even though you have permissions to view and edit not yours, there might be restrictions on the data source that prevent…

Did you confirm there was headcount for Dec 2023 at the time it was pulled? You may need to use something like COALESCE() if there are nulls. Maybe check date ranges to make sure you aren't filtering it out.

It doesn't necessarily require logging as an admin. But the account needs to have the necessary permissions to access all tickets.

Since each phone number is in the format XXXXXXXXXX, you can try \b\d{10}\b as a regular expression. This should match 10 digits surrounded by word boundaries.

This appears to work when I test it. It uses event.preventDefault to bypass the default action.

If the text is consistent….such as Jan always being "Jan"…you could split the values into multiple columns. One for the day and one for the short month name. Then convert the short month into its corresponding full month name, or use some logic in a formula to get the months back into a numeric. Then combine the day, full…

Is this what you are looking for? In Python….. import requests client_id = 'your_client_id'client_secret = 'your_client_secret'url = 'https://api.domo.com/oauth/token'data = { 'grant_type': 'client_credentials', 'client_id': client_id, 'client_secret': client_secret } response = requests.post(url, data=data) token =…

If you have checked for updates and you trust the source, you could go the Mac's Gatekeeper settings and try to bypass. Adjust Gatekeeper settings to allow apps from unidentified developers to be opened. Open "System Preferences" from the Apple menu. Click on "Security & Privacy." In the "General" tab, look for something…

It does not error when I click the preview. The file is xlsx.

@mroker - Glad to hear it's working. After you get your API configured, I suggest making sure the data structure matches your data. The JSON connectors will try to guess at what your data is. If your field holds a date, make sure its a date. Not a string, not datetime…a date. Make sure joining identifiers come across as…

Whoa. I feel for you. I really do. I used Salesforce many years ago after a company acquisition. But I did not have to migrate, it was a fresh start for me with the new company. I hope someone can add some good advice. I think you're going to have to do all the data mapping for the new organization first. Such as…

Potential reasons…. Permissions Issue: Ensure that the Google account you're using to connect to Google Analytics through Domo has the necessary permissions to access the views in Google Analytics. You need to have at least "Read & Analyze" access at the view level. Data Availability: Make sure that there is data available…

If you are trying to call an API, perhaps you could look at the Domo AppStore for an appropriate API connector. Search JSON. Some connectors require tokens or some type of authentication account to be configured. Possibly something like the No Code oAuth Connector. I use this type of connector to connect to my data source.…

In Domo, the route map feature typically allows users to visualize routes between two locations using latitude and longitude coordinates. However, creating a triangle with three variables (locations) is not directly supported in the standard route map feature.