ArborRose Coach

In your export, it might be affected by how you have configured the API, or how the data is stored in Domo's dataset. In the Admin > Toolkit there's a schema management tool for adjusting the data structure of a dataset. You may also consider using something like Python to perform your export. I use Python to export my…

I believe to change the dataset that your brick is connected to, you'll need to adjust the configuration within the brick itself. Open the configuration settings and look for the option where you specify the dataset that the brick is connected to. This is labeled as "Dataset" or something similar. Sorry, I'm not currently…

The error message you're receiving suggests that the Azure Active Directory (AAD) tenant where the application is registered does not have the specified application installed or consented to. This error typically occurs when the application (in this case, the one trying to connect to Sharepoint) is not registered in the…

Applying color rules at the cell level based on the comparison of two columns directly is not directly supported. As you mentioned, you can try to create a beast mode calculation that compares the values of columns A and B and sets a flag accordingly. Then, apply color rules based on the flag.

The error in the provided Domo code lies in the mismatched parentheses at the end of the CASE statement. You have an extra ) before the THEN 1 clause. (CASE WHEN week_id <= ( CASE WHEN CURRENT_DATE() BETWEEN '2024-02-10' AND '2024-02-16' THEN 1 WHEN CURRENT_DATE() BETWEEN '2024-02-17' AND '2024-02-23' THEN 2 WHEN…

Oh…make it less than but not equal if you want up to today but not including today.

The condition "<= month(CURDATE())" means compare years up until today's date. It is comparing Jan through today (April 18, 2024). For specific ranges like a specific month: To include records where the month is April - SUM(CASE WHEN YEAR(DocDate) = YEAR(DATE_SUB(CURDATE(), INTERVAL 1 YEAR)) AND MONTH(DocDate) = 4 THEN…

That's the formula I use. The version you show is not summing the full year. That month condition means it is summing YTD (year to date)…..less than or equal to the current month. You need to put some more criteria to it for the period you want. I am about to go to a meeting, I'll try to give you something specific when I…

I don't think there's a built-in feature. But you could create another column in the dataset to represent the colors based on your value criteria. And use custom marker icons (blue and red airplane icons), assigning them based on the data.

@Dobbrunz - the problem I had was that I could not find an example using Domo. I was eventually able to find a way to do it using blank brick. See my code and example below. The result is good but the implementation is too much work.

Applying PDP to a dataset restricts access to the underlying data. You still need to separately grant user access to view alerts that use that dataset. Make sure users have been granted appropriate permissions at both the dataset and alert levels to ensure they can access the data and receive alerts.

I believe in Domo, when you apply a PDP policy to an alert, it limits the data displayed in the alert, based on the permissions specified in the policy. Applying PDP to an alert wouldn't automatically grant access to view.

The following link is to a Domo created presentation. When we gave an internal presentation, we showed a brief slideshow of our topology. Then we demonstrated how we bring data into Domo, display it in Domo, and how we use extracts to populate other information on our network. I would suggest you use an existing dashboard…

I think it would depend upon the specific functionality and actions that the add-in performs.

In most cases, the expires_in value is expressed in seconds. Therefore, in your example, the expires_in value of 3599 indicates that the access token is valid for approximately 3599 seconds, or about 59 minutes and 59 seconds.

That's a question for Domo. Possibly someone else can comment with another way.

One way you might be able to get it would be through the Domo API using Python. import requests Set up authenticationheaders = { 'Authorization': 'Bearer YOUR_ACCESS_TOKEN' } Make API request to retrieve user profileresponse = requests.get('https://api.domo.com/v1/users', headers=headers) Check if request was successfulif…

The original posted question mentioned the dataset changing every morning. And that refresh was over-writing the responses entered. If you use more than one dataset, you can refresh the main set without impeding upon your answers in another. Use a "key" field, like an ID that is common to both. In the data, let's assume…

Okay…I see the connector you posted. It shows the credentials need to come from the azure portal active directory. That can get tricky and possibly involve firewall ports.

Have you reviewed the Domo information page? Have you attempted a connection and now receiving an error?

@Ashleigh - Thanks. Yes, it looks like it save it this time.

Hmmm…unfortunately it doesn't save when you hit apply. I made the change, hit apply. But when you open it back up, the triggers didn't change. Apparently you still have to hit the save and run.

Colemen's answer refers to having json coming through an API. As Jason mentions, the workbench can simply load it in from a file. Find Domo Workbench under Admin > Tools.

Argh. I was trying to stay off the forum so others can answer. But I recently had to solve this for myself. I created an ETL with an aggregate tile grouped by whichever fields were needed. With the visits in an aggregate and the amounts in another aggregate: The trick here is the count distinct values. Then AFTER this…

It's been a minute. I have to re-read the problem to see what it is you are trying to solve. Then I need to recreate a data sample. You say, "It is going in a gauge card, I just provided the table for context into the data." So you want a date filter, a table of data, and a gauge showing the percentage of repeat customers…

Ah, nice. Thanks for that information.

@Ashleigh - I know this is an older post but I'm curious…how did you get to settings on an ETL? That might have changed. I need to change triggers on an ETL that takes 45 minutes to run. I don't want it to start and then have to cancel it. I simply want to change the triggers before it runs this morning. Settings doesn't…

I've also noticed after hitting "validate" to validate the code, when you hit Save and Close it doesn't….close.

We haven't completed the setup of the Domo NetSuite connection yet. Your question is a nice reminder that I need to move some focus back to that topic. Have you looked at the Domo NetSuite Connector?