ArborRose Coach 
コメント
-
DATA_APP would be the app such as a Custom App, Brick, or App Studio app. The number looks like an internal id for that app in Domo. It's a unique number associated with a specific app. It looks like Domo found a dependency that your user does not have access to. You could try finding the app using the id. Such as…
-
I’m familiar with the abandoned warning, but this was an active dataset, just like others showing the same indicator. The only thing suggesting an issue was the AI readiness message. Once I defined a column as an identifier in the AI dictionary, the lineage appeared. It's not that I am completely against AI. But Domo isn't…
-
A true dropdown component is not supported in standard table cards. Those cards are intentionally limited to data display and navigation actions. If dropdown behavior is required within the card itself, a custom app (via the Domo App Framework) is an appropriate path, with writeback handled through Domo APIs. However, it’s…
-
I don't like this. My head hurts. 😵💫 If I'm wrong, I'm wrong. I barely understand the question. Using a sample dataset of: Month End Date,YTD_Amount,Month,Fiscal Year,FY End Date 2024-02-29,1000,Feb,2025,2025-01-31 2024-03-31,2200,Mar,2025,2025-01-31 2024-04-30,3500,Apr,2025,2025-01-31 2024-05-31,4800,May,2025,2025-01-31…
-
Here's a blank brick example. Go to AppStore, search blank brick. When you create a dashboard, you will fill in an area with JavaScript, html, and css. Here's code. JavaScript: var select = document.getElementById('animalSelect'); var output = document.getElementById('output'); select.addEventListener('change', function ()…
-
You could make a dropdown in an html card. Which would look just like a regular table card…but alas, how would you get the selected value to pass back to the Domo filters. You could create a custom app or use a brick.
-
… peanut butter with no jelly. 🥪 … a phone with no charger. 🔋 … a keyboard with no "S" key ⌨️ … Domo without the community forum. 😏
-
I don't work with that writeback connector. But I here are a few thing I would try. • Make sure all folders are already created. (Don't assume a connector can create folders.) • Keep naming simple. Use snakecase with underscore_instead_of_spaces. Avoid special characters. • Use the main site, not a subfolder. At least to…
-
Take a look at the Governance Connector. https://domo-support.domo.com/s/article/360056318074 It has a beast modes dataset the includes: Fields: Card ID, Card Title, Dataset ID, Dataset Name, Beast Mode ID, Beast Mode Name, Beast Mode Formula, Beast Mode Status, Beast Mode Saved to Dataset, Beast Mode Applied to Summary…
-
I don't think there's a "one click solution". But you could probably migrate content using Domo Sandbox. Enable sandbox in the source instance. Then invite the destination instance to the sandbox and create a repository of objects. Then share and promote to the destination instance.
-
You can create it with a beast mod4e instead of adding rows. CASE WHEN `Series` = 'Goal' THEN 150 END And if your dataset includes a market column, drag that to the filter section or add a page filter.
-
Using a sample set, I'm thinking you are asking for something like this: Quarter,Series,Value Q1,2023,120 Q2,2023,140 Q3,2023,135 Q4,2023,150 Q1,2024,130 Q2,2024,145 Q3,2024,160 Q4,2024,170 Q1,Goal,150 Q2,Goal,150 Q3,Goal,150 Q4,Goal,150
-
Save the following code with an html extension, then drag it up to your Chrome browser to see example. <!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8" /> <title>Date Range Filter Prototype</title> <style> body { font-family: system-ui, -apple-system, BlinkMacSystemFont, sans-serif; background: #f6f6f6;…
-
We are working blind without an example. Can you create some fake / sample data?
-
Trying taking your deviation formula, in whole, and put it into your next step. Account Payments (cash, model) * ( SUM(CASE WHEN Month <= CURDATE() THEN Account Payments (cash, actuals, projected) END) / SUM(CASE WHEN Month <= CURDATE() THEN Account Payments (cash, model) END) ) And since you don't want a divide by zero,…
-
I agree - that looks like a Domo issue.
-
I believe David is onto the basic problem…aggregation. Something like this should work: SUM(row_value) × aggregated_metric Something like this will not: SUM(row_value × aggregated_metric) Your deviation ratio is already an aggregated calculation because it uses SUM. And Domo isn't allowing nested aggregations.
-
I'm not sure that you can. I think it just leaves orphans behind if you delete the app without first deleting the contents. You could try using the Governance Toolkit to identify the lineage /asset to find which apps reference which cards.
-
Sounds like a good submission for a product idea. I don't do a lot in pro-code but I had a similar issue when I did. I couldn't find the notes after saving them. So, I wrote my notes and comments in the code. And when I saved the files, I put the version in the filename, mycode_v1_12.js. /* VERSION 1.14 2026-01-27 -…
-
In Domo, YTD breaks when you use a month filter because filters remove prior months (history) before beast modes run. I'd try to use a variable - or handle it in Magic ETL using a month-year field and pre-calculating YTD by year and month.
-
It depends what you are converting…labels, or full sentences. I typically setup a variable for "language" where the values would be things like "EN" for English, "ES" for Spanish, etc. Most recently I use AI to do the translations to populate the look up table. key EN SV revenue Revenue Intäkter profit Profit Vinst date…
-
Congratulations Elliott! One of us! One of us! One of us!
-
I don't work with BigQuery, but there are documentation pages that show example queries. https://developers.google.com/analytics/bigquery/basic-queries https://developers.google.com/analytics/bigquery/advanced-queries The documentations shows that the specifics (ie. fields) are nested as you stated. The page for basic…
-
Both parts are valid. This is non-aggregated: DATE_FORMAT((CURRENT_DATE() - INTERVAL 1 DAY),'%a') This is aggregated: COUNT( CASE WHEN DATE(`Opened At`) = (CURRENT_DATE() - INTERVAL 1 DAY) THEN `Opened At` END ) The CASE produces row-level values, and COUNT aggregates them into a single result. So each works on its own,…
-
This is the only link I can find: https://community-forums.domo.com/main/discussion/69144/sendemail-function-via-api/p1 Here's a JavaScript example of a fetch call: async function invokeHelloWorld() { const url = "https://<yourDomoInstance>.domo.com/api/codeengine/v2/packages/abc123-def456/versions/1/functions/helloWorld";…
-
I believe the issue isn't the way the visuals are displayed, but the way you are creating the underlying value. Make sure your value is a real percentage in your ETL. In the table, it multiplies by 100 such that a raw value of 0.473 shows 47.30%. If the raw value is 47.30, it shows 4730% instead of the calculated percent.…
-
You have an aggregation with a non-aggregated formula. I think it's having a problem grouping. It can do the date_format by itself but not while trying to do the count. What happens if you wrap the data format with a MIN statement?
-
I don’t think you’re imagining it, but I haven’t been able to find any documentation confirming that this behavior changed. I could be missing something. From the outside it seems intentional rather than a bug, but I don’t know that for sure. Personally, I’d really like to see support for both global (persistent) variables…
-
I had nothing. Except tacos. Tacos are the answer to most things. But I'm not sure our members will click "Love this answer. Mark it awesome!" The poem — just the observation that a quiet forum isn’t necessarily an empty one.
-
Still water reflects the sky; sunshine gathers on the surface. 🌞
