Comments
-
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:
-
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…
-
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, '-', FLOOR((`maint_count_between_restarts`+5)/5)*5) END
-
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.
-
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
-
Currently, dynamic column headers aren't supported. I'd recommend logging an idea in the idea exchange.
-
Hi @Data_Devon - I'd recommend restructuring your data to allow more flexible period over period analysis. I've done a write up here with it: https://community-forums.domo.com/main/discussion/53481/a-more-flexible-way-to-do-period-over-period-comparisons#latest
-
I'd recommend creating a new stream and uploading each excel document as part of the stream and then close out your stream. Domo has a Python example on how to use streams here:
-
Is the value actually NULL or is it a string value of "{null}"
-
Are you passing in the User ID (not the user name or email but the Domo internal user id) for the user's role you want to update?
-
@Ashleigh has used Course Builder heavily in the past but I'm not sure how well it's maintained currently. I'd reach out to your AE or support if you have questions
-
You'll need two different apps currently. I'd recommend logging an idea in the idea exchange to allow for more granular app page level access.
-
You can use a beast mode to do a running total: SUM(SUM(`Metric`)) OVER (ORDER BY `Date`)
-
Try using a Grouped Line + Bar Chart under vertical chart types.
-
Currently these aren't exposed to the AI readiness. I'd recommend logging an idea in the idea exchange.