GrantSmith Coach

You can use a window function to calculate the row number/rank. SUM(SUM(1)) OVER (ORDER BY Score) You can add any partition to your OVER clause if you want the ranking to be within a specific partition

You could utilize a card with a beast mode and summary number to calculate the number of records where they are different and then alert on the card if the summary number is > 1 SUM(CASE WHEN `col1` <> `col2` THEN 1 ELSE 0 END)

Have you used the CLI's define-upsert command to define your upsert key on your dataset? I don't think pydomo supports Upsert Keys out of the box.

Have you tried creating a new Domo Connector Account to authenticate with and see if that's still the issue? Are you able to login to JIRA with those same credentials?

It sounds like you're wanting much more control over how your cards are displaying images. I'd recommend looking into writing a custom Pro Code app to toggle between displaying an image or the card depending on the filters selected.

You'll need to add a note and discuss it with the App Team when submitting it to the app store. They likely will be able to make it an unlisted app.

This sound like a back end issue. I'd recommend logging a support ticket for them to investigate.

The standard connector won't be able to do this as it's not designed that way. You could look into attempting to setup your own connector via the JSON No Code connector or develop a custom connector.

Currently this isn't available.

You can use COALESCE and NULLIF. COALESCE(NULLIF(TRIM(`Quantity`), ''), 0)

If your dataset has a single row for each month and all months are accounted for you can use a Rank and Window with the LAG function to pull the prior row (month in this case). Alternatively you can use a formula tile to split your dataset by setting your MonthEndDate to the prior month `MonthEndDate` - INTERVAL 1 MONTH…

Beast Modes wouldn't support this as there are layers of permission. There are DomoStat datasets which list all of the pages and cards you can use to get this information (Cards & Pages dataset).

Currently, there is no functionality built into Domo to jump to a specific tag or section. I'd recommend logging an idea in the idea exchange. Here's one idea that's similar - I'd recommend upvoting it: https://community-forums.domo.com/main/discussion/59197/inter-page-sectional-jumping

As a workaround I've had success removing the group from the page and then re-sharing the page with the group.

I don't think they have the documentation available anymore but if you run wb.exe --help from the command line it'll tell you the different commands it can run for you with documentation for parameters.

You can query the API to get a list of variables based on a filter. API: https://{{instance}}.domo.com/api/query/v1/functions/search POST Body: { "name": "", "filters": [ { "field": "variable" } ], "sort": { "field": "name", "ascending": true }, "limit": 1000, "offset": 0 }

To my knowledge this is intended so users can't modify other user's embedded settings.

You can get something like this with a Spark Line chart (under Other Charts chart type in analyzer)

Domo reverted the v5 layouts in favor of the older v4 due to these types of issues while they reassess the rollout.

Domo has rolled back the new v5 dashboard layouts and reverted back to the v4. With v5 you have to select the card first before it'll show the resize handles to allow you to resize a card

You might be able to use a beast mode to do a ROUND function to round your number to 8 or 10 digits. This may not dispay if it's still a a number so you may need to format it as a string first using CONCAT but that would prevent you from doing numerical aggregations on your number. It depends on your use case and how you…

Hi @SPD You can use the Alter Columns tile in Magic ETL to convert your string to an integer and then compare both integers together.

This sounds like a bug with the deployment process. I'd recommend logging a ticket for Domo Support so their team can review their internal logs and help address the issue.

You can get the first day of the week using a beast mode: -- Description: Get the first day of the week -- This is done by subtracting the day number (1-7) from the given date. -- 5 (Thursday) - (5-1) days => 5 - 4 = 1 (Sunday) DATE_SUB(`dt`, INTERVAL (DAYOFWEEK(`dt`) - 1) DAY) You can find other helpful formulas I've…

https://community-forums.domo.com/main/discussion/comment/102265#Comment_102265 There's an edge case which is causing the wrong labels. Try the following: CASE WHEN `maint_count_between_restarts` = 0 THEN 0 WHEN `maint_count_between_restarts` > 50 THEN 50 ELSE CONCAT(FLOOR(`maint_count_between_restarts`/5)*5+1, '-',…

Since your buckets are the same size you can use some math and concat to calculate your buckets for you: You can take care of the end buckets first otherwise calculate the bucket name dynamically. CASE WHEN `maint_count_between_restarts` = 0 THEN 0 WHEN `maint_count_between_restarts` > 50 THEN 50 ELSE…

You need to use a lowercase o for onDataUpdate. https://developer.domo.com/docs/guides/handling-data-updates?category=/docs/embed/embed-2

You'd have two separate beast modes for each different metric and the offset type For example Current Year's Budget: CASE WHEN `Period Type` = 'Current' AND `Actual or Budget` = 'Budget' THEN `Charge Quantity` END Last Year's Budget CASE WHEN `Period Type` = 'Last Year' AND `Actual or Budget` = 'Budget' THEN `Charge…

You can add a FILTER NONE option to ignore all filters applied. https://domo-support.domo.com/s/article/4408174643607?language=en_US

Currently this isn't possible with a single select however you could have multiple single select filters to get the AND functionality. I'd recommend logging an idea in the idea exchange to add this functionality