GrantSmith

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)

で Setting alerts for comparing two column values. GrantSmithによるコメント 09/23

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.

で Create Primary Key on Dataset GrantSmithによるコメント 09/23

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?

で Jira Issues Connector broke GrantSmithによるコメント 09/23

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.

で Dynamic tiles on a dashboard GrantSmithによるコメント 09/23

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.

で Appstore: Hidden Apps GrantSmithによるコメント 09/23

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

で No Code JSON connector error 'Unable to tunnel through proxy? GrantSmithによるコメント 09/23

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.

で SharePoint list and lookup value field GrantSmithによるコメント 09/16

Currently this isn't available.

で Beast Mode Folders GrantSmithによるコメント 09/15

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

で How can I get null/empty string fields to appear as zeros in my ETL? GrantSmithによるコメント 09/15

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…

で Previous Month with Lag Window Function? GrantSmithによるコメント 09/11

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).

で Dynamically retrieve dashboard where card is saved GrantSmithによるコメント 09/11

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

で Buttons to navigate on a Dashboard GrantSmithによるコメント 08/29

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

で DOMO Group Access to Dashboards GrantSmithによるコメント 08/28

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.

で Trigger a workbench job from a sql script GrantSmithによるコメント 08/27

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 }

で how to get a variable ID? GrantSmithによるコメント 08/18

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

で DOMO creates different embed ID for different users GrantSmithによるコメント 08/18

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

で Next Level KPI GrantSmithによるコメント 08/12

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

で 8/7 release issues GrantSmithによるコメント 08/08

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

で Dashboard v5 Issues - Formatting size of content GrantSmithによるコメント 08/08

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…

で Can I get more than 6 decimals? GrantSmithによるコメント 08/06

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.

で Conversion - String Field to Integer GrantSmithによるコメント 08/02

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.

で Promoting App, ERROR creating variable control GrantSmithによるコメント 08/01

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…

で Make Pivot table display first day of week when graphing by week GrantSmithによるコメント 07/11

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, '-',…

で Use loops to avoid rewriting case statements within a beast mode many times GrantSmithによるコメント 07/09

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…

で Use loops to avoid rewriting case statements within a beast mode many times GrantSmithによるコメント 07/08

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

で Getting error "domo.OnDataUpdate is not a function" GrantSmithによるコメント 07/01

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…

で More Efficient YoY Actual to Budget View GrantSmithによるコメント 05/23

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

で Find Max rank from a ranking column and fixed it so it doesn't change when filter applied. GrantSmithによるコメント 05/23

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

で When using a multi-select filter, can this be used as "AND" logic instead of "OR" logic? GrantSmithによるコメント 05/23

Currently, dynamic column headers aren't supported. I'd recommend logging an idea in the idea exchange.

で Is there a way to dynamically format data labels for header columns? GrantSmithによるコメント 05/23

GrantSmith Coach

コメント