brycec Contributor

You can add a sort for the maximum of that column descending.

To add to this, it would be nice if transposed mega tables also could use alternating row colors. Right now, the option remains and can be selected. However, it causes the first column to be one color and the second column to be the other color. Its behavior should be updated to alternate on the new rows that used to be…

@Data_Devon, When you add the Beast Mode as a filter on the card, you need to select and apply its value as 'Yes'. Then, when the variable value is set to 'MTD', for example, the CASE statement then evaluates the second CASE statement on that line. When true, it will produce 'Yes', which matches the value you selected in…

I would reach out to support about this and also email your CSM/AE. Let your CSM/AE know how it is affecting your instance and what that means for your business. This will help them push the support ticket through as priority. I wouldn't know if these features are gone since I've never used them myself. But a while ago,…

This would be incredibly helpful. Buzz is disabled in our instance, so this button just sends an email to the owners of that resource. We handle access requests in a ticketing system. Any way to modify this button to redirect to the ticketing system, send an email to a specific email address every time, or disable the…

Their API is a little weird. Looks like there is no way to just retrieve survey responses. You either get them at submission via the webhook or you can do an export. The problem with the export is that you must create it, wait for it to finish, then download it. In Domo, this would require you to setup a script somewhere…

That's odd. I haven't run across that endpoint ever. When you manually sync something in the AppDB viewer, it does a PUT request like I was saying. You could try to just switch to the PUT request for documents, seeing as that POST request isn't working anyway.

In order to add or modify documents in a collection, you'd need to use a PUT request. You might already be doing this, but all I see in your post is your domo.get request, which would need to be domo.put. Also, you might want to look into using the table section component on the Form Builder app or the Inline Editing app.

I've done this with a DataSet that was grouped by month, so that it could be changed to by quarter or year and still be getting only the most recent value of those time groupings and not duplicate. I imagine the same concept can be used by day too. I achieved that with the following formula: (CASE WHEN Month =…

Replied in your other post: Connect to Notion to Extract items form Database — Domo Community Forum

This is possible using the JSON connector. In the Parsing setup step, you can configure the pagination for your request. For Notion, select the type of "Get next page token from results". Then, select "Add as a parameter" for the option "Select how the token should be used". Then, input the parameter name as start_cursor.…

I like your attitude! I found this article on how to calculate distance in Excel: How to Calculate Distance Between Two Addresses in Excel. Beast Mode SQL doesn't support the necessary functions, but Magic does. To calculate straight line distance in miles, you'd just use this formula in Magic: 3959 * ACOS(COS(RADIANS(90 -…

Not sure what is wrong with the connector, might be a bug on Domo's end that you need to submit a support ticket for. But, you should be able to use the JSON No-code OAuth connector with the Xero API to get around that.

Oh, great point @DavidChurchman! Even better, there is a way to add all those Current Pages to the Summary Number. Simply use the LISTAGG(`Current Pages`) and you should be set! There is no way to adjust the LISTAGG separator, but you could just do REPLACE(LISTAGG(`Current Pages`), ',', ', ') to change it to have a space…

Commenting to remove from unanswered

@cadellfalconer I do use governance toolkit, as well as the APIs. The toolkit is limited by the inability to edit a job, and that a new job must be created every time you want to create virtualized DataSets. It would be very nice if the toolkit could be an automation, much like how other toolkit jobs work. For example, I…

There isn't a way to add a field without it being a filter to smart text. You could add it as a filter, and select all, to add it. There also isn't a way to add smart text to an Excel export unfortunately. I like that feature idea, you should create a post in the ideas exchange to start getting the product team to look at…

You can go to your profile picture in the top right of Domo, then click the gear icon in the top right of that modal. Then go to the notifications tab and uncheck the SMS column (3rd column) for the line "A Card or Dashboard is shared with you". I assume that works with App Studio Apps too, but I haven't specifically tried…

What type of chart are you using? You have a property called balanced_distribution that isn't on the default bar chart and I cannot find what type of chart uses that property.

Have you tried removing the import statement? Code Engine is weird and it might just be built in and allow you to call that Domo function without the import statement. Otherwise, you can use the requests package instead the Python SDK.

One of the functions in the DOMO Notifications action should do what you want. You can find them by adding an action in a tile and searching for email.

You could instead use goals/objectives to achieve this, since they do have key results that track percent (or other measure) complete. Otherwise, you could pull the DomoStats reports for Projects and Tasks and display them in cards. You can collect the priority and estimation from workflow forms, an app, etc. and add that…

API documentation from Domo has been historically poor. You are using the OAuth API, which usually changes versions if there are significant changes. But, API development has also historically been disorganized and not well managed. There isn't a list of changes anywhere that I've found unfortunately. When these changes…

I assume this Domo connector doesn't do what you need, but I wanted to bring it up in case you hadn't seen it. I'm not familiar with the Amazon Vendor Central: Amazon Vendor Partner. Assuming the above doesn't work, there appears to be an API for the Amazon Vendor Central: Vendor Central URLs. You can then use the JSON…

You can use an alert on a card, so that you can add those conditions as filters on the card. Then, add an action to the alert that triggers a workflow. That workflow can then create a task in the task/queue center for the owner to fill out.

You'll want to use the append tile instead if the structure of the data is the same. Append will add rows to the bottom of the other DataSet, without increasing columns. Joins is for joining on keys and will increase the number of columns you have. If you still need join, you just have to use multiple join tiles one after…

I was playing around in the Product APIs and found that editing Virtual DataSet jobs is possible via the API, just not the UI. 1. Get the applications (different toolkits): GET https://<your_instance>.domo.com/api/executor/v1/applications 2. Use the application ID for the Virtual DataSets to get all the jobs: GET…

Some of my favorites from Gemini: Vance's Vanguard Thompson's Titans The Visionaries The Data Diopters The Insight Iris The Retinal Rockstars The Cornea Commanders The Focus Force The Data Sight Squad The Pixel Pupils The Analytic Acuity The Clear View Crew Vance's Visionary Diopters As someone who inherited a Domo…

Have you checked out the developer documentation? DOMO Developer | APIs They have recently started documenting their "Product APIs", which are extensive.

I played around with the API and tried to find a way to change the owner. As far as I can tell, it is not possible. The best thing you can do is probably just create a new one and replace everywhere the old one is used, as sucky as that is.