GrantSmith Coach

Wrap your entire outer/first case statement in a SUM function and replace all SUM(`Budget`) with COALESCE(`Budget`,0). Do the same for Actual its doing the subtraction after all records have been added together instead of summing the differences for each record causing the discrepancy

Currently there isn't a simpler way to do this within Magic ETL. You could attempt to utilize MySQL dataflow to programmatically rename the columns if you have a consistent format you want to rename it with.

Are you aggregating anywhere else within your card? If so Domo doesn't know how to handle the results of your window function as it returns a single result for each row.

Another alternative is to re-architect your data so that you have different offsets for your different dates. This way you can select the current year but show the current year, last year or any other period you've defined. I've done a write up on this in the past here:

The card errors happen when the card is rendered but not recorded. The closest you can get is having the status at a specific time and then look through those cards specifically. There isn't a real-time option to see which cards are actively broken.

Due to how DDX bricks are designed and iframes work in general this isn't possible. <iframe> is another separate browser window. It's just a means of 'seeing' inside that web document through your parent document. It's different than a normal in which you can extend elements outside of its margins. Also, it is considered a…

You'll need to log a ticket with Domo Support as they control the code to this connector and would be able to give you a bit better support as they would have access to their internal logs.

The DomoStats connector has a new dataset called Card Loads which will return an error code to see if it was a Success or not.

Currently this isn't an option within the smart text. I'd recommend adding an idea to the idea exchange. You can utilize an ETL to populate a field within your dataset to show the date / timestamp when the data was updated in your dataset and then use that field in the smart text.

Without having more information about what your issue is I'm assuming it's dealing with your prev month where it's subtracting a month. You want to make sure you subtract a month from your date before getting the month and year for it. CASE WHEN 'metric'= 'CURR MONTH' THEN CONCAT(MONTH(NOW()),'-',YEAR(NOW()) WHEN…

This sounds like a bug with Inline Editor. I'd recommend logging a ticket with Domo Support to have them investigate the code on their end.

Have you tried using a window function and adding it to your sort at the top so it's sorted first? SUM(SUM(`Balance`)) OVER (PARTITION BY `CustName`)

There isn't a programmatic way of doing this but you can edit the beast modes a bit easier within the Beast Mode Manager instead of having to do it by opening up individual cards.

I'd recommend logging a ticket with Domo Support as it sounds like a bug with Workbench they'd need their development team to look into.

Depending on your groupings and the metrics you're calculating you can either group by and then join it back to your original dataset like you mentioned or possibly use a Rank and Window tile to do your aggregation within your entire dataset and leave your columns in place. But @ColemenWilson mentioned, aggregation drops…

What is the students field? Is that the number of students, or is it some other value? Is it numeric or text?

It sounds like you want a custom app that you can do and have control over the different sliders on your app to then trigger an event to call your ML model API. You can't call an API from directly within a card. You can read up more on custom apps here:

What do you mean Admin access? Workbench is a windows application so anyone who has admin access to the machine has admin access to Workbench. If you're talking about authentication, no, only one Domo user can be authenticated with workbench and Domo

What issues are you running into with the JSON connectors?

CASE WHEN MAX(`Attendance Type`) OVER (PARTITION BY `Event UNID`) = 'Video' THEN 'Yes' ELSE 'No' END You can use a window function to return a value across an entire bucket (in your case the event). MAX will return Video if a video record exists (it comes alphabetically after Phone). Wrapping in CASE statement to return…

CONCAT(SUM(CASE WHEN `` = 'Forward to HM' THEN 1 END), ':', SUM(CASE WHEN `` = 'Hire' THEN 1 END)) You can use a CASE statement to conditionally SUM your records together and then use a CONCAT to put everything together in your ratio format.

Nope, this should be just fine.

You can utilize LAG functions to do a rolling average. I've done a writeup on this here:

If you don't have a column already named the same as your beast mode or another beast mode named the same I'd recommend logging a ticket with support. I've occasionally seen this happen and needs Domo Support assistance.

If you're pulling in Daily data and don't need to keep more than 3 years of data partitioning would be easiest for you to utilize.

The append endpoint doesn’t exist hence the 404 try using data?updateMethod=APPEND

404 means you’re trying to access something that doesn’t exist. Does your UTL correctly include the proper dataset id?

you can use AND to combine logcal expressions together if both should be true or OR if one needs to be true. Alternatively you can add an additional WHEN clause to your case statement to do something diffferent: CASE WHEN `primary class` = 'supermarkets and grocery stores' THEN SUM(CASE WHEN `Split answer` = 'Female' THEN…

You'll want to log a ticket with Domo Support as they own the connector and is likely something in their code which needs to be updated.

CASE WHEN DATEDIFF(CURDATE(), `Date Field`) <= `Days Variable` THEN 'Include' ELSE 'Exclude' END