GrantSmith Coach

@GrantStowell , @ArborRose - Challenge accepted. 😈 Also, Congrats @ellibot!

Domo does actually store your files if you upload and use them in an image card and give it a unique ID. It have a URL you can access directly in the format of https://INSTANCE.domo.com/api/data/v1/data-files/FILE_ID. If you want to keep everything in Domo you can upload them via card files and then reference their URL.

Workbench Enterprise is essentially a self contained Docker container which allows you to run it via a web browser and be platform independent rather than requiring a windows machine. It's a bit more technical to get setup and configured which has been a hinderance for some (you're essentially setting up a web server). It…

If you're regularly updating a chunk of data you can leverage the CLI to run the partition-dataset command to add partition keys to your dataset. If you want to go an upsert method route you can also leverage the CLI's define-upsert command to define your upsert keys. Note: Upsert is only supported when appending data.…

What type of format are you wanting in Google Sheets? If you're looking for the raw data, you could use a Google Sheet writeback connector in an ETL to write it. If you want more visualizations, you can use Domo Everywhere to embed the data. Embedding a dashboard within Google Sheets isn't easily feasible without jumping…

You can take out your ELSE NULL as it will default to NULL if none of your conditions are met.

This sounds like a potential bug. I'd recommend logging a ticket with Support

How are you going to utilize the total time? Does each row in your dataset need to have the total or can you just ignore the task column and aggregate based on the Name, ID and SUM(TIME)? If you're looking for the total on each row you can use a window function: SUM(SUM(`Time`)) OVER (PARTITION BY `Name`, `ID`)

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…