ArborRose Coach

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.

In Domo, you can set up alerts to notify you if the alert has not fired in 72 hours or if there are errors preventing it from firing. Here's how you can do it: Setting up Alerts for Non-Firing: Go to the page where you have set up the alert. Click on the alert you want to modify. Look for the option to set up a schedule or…

If I grasp the question correctly… If you are setting up an API, you want to go to the Domo AppStore and find the proper API connector. Type JSON in the search. Something like the JSON no code connector. In the connector you will input your settings like the URL you show. "updateMethod" looks like a parameter. You should…

I'm using current_timestamp(). Which gives me a date and a time. I plan to only pull once per date. Which makes the time unnecessary. But if I (or another coworker) triggers it to pull more than once in a day, I need to make sure it can tell which pull is more recent.

@mroker - have a look in recent discussions for my question on "Effective Dating". This sounds exactly like what I am doing and the solution I created appears to work. My dataset is coming from an API scheduled daily. I append any records that are new or change to create an archive.

What if on a given day, a patient schedules more than one appointment? Wouldn't using a rank of 1 give me only one of the appointments, or a change in appointment, but the others would be lost?

I appreciate the help and insights. I may not be doing this right…but the unique field I'm using is my archive timestamp and my partition is set to all the other fields. This puts every record in a chronologic order. Then when I remove duplicates on the next tile, it leaves me all the records that are new or changed. If my…

That is what I am doing in example I showed. I created that ETL yesterday and ran it. Now I have this morning's data…it appears to work. Based on what I see, I have records of just the changes or new appointments. I'm still validating the data. Next, I will need to do the query portion of retrieving based on the effective…

In the new ETL features, the Group By tile now has a concatenation for strings. Have you tried it?

I don't believe you could do it in the API. As you state, you can implement that after receiving the dataset. I would think it would rely on the source of the API implementing the partition.

A follow-up comment to my mock-up. I need to see what was recorded based on the entries at that time I take a snapshot of the changes. A record may say an appointment took place on date X. It does not matter what the date X says. I need to order my records based on what was in the data…not based on what the data says. So…

@Colemen, I mocked up an example of how I think I will implement this, below. Every morning I gather the current appointments. I need to build a dataset of all appointments, but only where there are changes in any field. This keeps the dataset smaller. In this example, assume I want to see a view of what the appointments…

Convert the time values to numerical format. Then sum up the numerical values. Convert time values to seconds: If your time values are in the format "HH:MM:SS", you can use the following formula to convert them to seconds: (hours * 3600) + (minutes * 60) + seconds. For example, for the time value "00:04:25", the…

With Windows 11, the Snipping Tool has a copy text feature.

You can try using your browser's developer tools to inspect the element containing the number and manually copy it from there. This method requires some familiarity with HTML and JavaScript. Or export and then copy.

Check your workbench configuration, API credentials, configurations and endpoints. Review logs to read the details. Verify your data sources are still accessible. Check network connectivity. Make sure there's no network issue preventing Domo workbench from accessing the data source. Restart workbench and server. Sometimes…

It seems like Domo is aggregating the data based on the "maximum number of items" setting you've specified. When you set the maximum number of items to 2, Domo is likely displaying the top two countries with the highest values and then grouping the remaining countries under an "Other" category. In your dataset: The highest…

You are putting 2 into maximum items. That's not top 2. Look where it shows LIMIT ROWs. Set that to 2. And remove 2 from maximum items.

I still don't get that result with a tooltip. If your data comes from Excel, try formatting the columns before using it.

Can you show us what you are doing with tooltip? I do not get that response from Domo based on what you show…assuming your fields are defined as date, text, and numeric as shown below.

Can you cast the varchar(10) to be varchar(25)? SELECT t1.EventID, t2.OtherColumn FROM Table1 t1 JOIN Table2 t2 ON CAST(t1.EventID AS VARCHAR(25)) = t2.OtherColumn

According to Domo support documentation, Domo Workbench has no limit. I use Workbench to schedule daily uploads. If that doesn't work, you might be able to do it with Python. I extract using Python but I never tried uploading using Python.

I don't work with R, but I have a friend who has significant R experience. Passing this along…. Check Internet Connection: Ensure that your internet connection is stable and that you can access CRAN (Comprehensive R Archive Network), where R packages are hosted. Sometimes, network issues can lead to failed installations.…

The regular expression you're trying seems to be incorrect. Explanation: (?<=,\'): Positive lookbehind assertion to match the position right after ', without including it in the match. (.*?): Non-greedy matching of any character (.*?) between the ', and ',. (?=\',): Positive lookahead assertion to match the position right…

Could there be a difference in permissions between users? Does this user have access to something others do not, thus adding to the "weight" of the file? Things you might want to try: 1. Make sure there is consistent access to the SharePoint location where the file is located as well as associated resources. 2. Check data…

Are you all using the same environment? Is the other team member on a different system? Have you checked to make sure the add-in used is up to date? Sometimes issues and bugs can be resolved by updating to the latest version.

You may not need to store a snapshot to compare old data to new data. Depending upon the data, you can do a trend of Year over Year, Month over Month, Year to Date, etc. Look under chart types for Period over Period. YTD comparisons can also be done with formulas representing current year, previous year, previous 2 year,…

The error message you're receiving indicates that the Domo API endpoint /domo/workflow/v1/models/RunDataflow/start is returning a 404 Not Found status code, indicating that no workflow was found with the name "RunDataflow". Here are a few steps you can take to troubleshoot and resolve this issue: Verify Workflow Name:…

I use recursion to create a snapshot of a dataset. A simple google search "Domo recursion" will give you an example.