ArborRose

That did not work, so I added a space. ;)

in Going to Domopalooza without Pre-Conference Training is Like... 🤔 Comment by ArborRose 6:27PM

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 ()…

in Adding Dropdowns in Domo Table Cards & Other Cards Comment by ArborRose 3:35PM

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.

in Implementing In-Cell Dropdown Selectors: Standard Table Card vs. Custom App (DDX) Comment by ArborRose 3:21PM

Um…why did that make a bullet?

in Going to Domopalooza without Pre-Conference Training is Like... 🤔 Comment by ArborRose 3:10PM

… peanut butter with no jelly. 🥪 … a phone with no charger. 🔋 … a keyboard with no "S" key ⌨️ … Domo without the community forum. 😏

in Going to Domopalooza without Pre-Conference Training is Like... 🤔 Comment by ArborRose 3:09PM

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…

in SharePoint Writeback Connector Comment by ArborRose February 2

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…

in Beastmode DomoStats Dataset? Comment by ArborRose February 2

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.

in Migration from one Domo instance to another Comment by ArborRose February 2

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.

in Line Chart with Goal Comment by ArborRose January 30

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

in Line Chart with Goal Comment by ArborRose January 30

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;…

in Date Range Filter with Start Date and End Date (Manual Entry + Calendar Picker) Comment by ArborRose January 30

We are working blind without an example. Can you create some fake / sample data?

in Sales Modeling Correction Calculation in Pivot Table Comment by ArborRose January 30

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

in Sales Modeling Correction Calculation in Pivot Table Comment by ArborRose January 29

I agree - that looks like a Domo issue.

in AppDB issues Comment by ArborRose January 28

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.

in Sales Modeling Correction Calculation in Pivot Table Comment by ArborRose January 28

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.

in How to delete App and the cards being used in the App? Comment by ArborRose January 28

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 See version notes in pro-code editor? Comment by ArborRose January 28

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.

in YTD calculation breaks when using Month filter in Domo – best practice? Comment by ArborRose January 27

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…

in Multi-Language DAshboard Comment by ArborRose January 26

Congratulations Elliott! One of us! One of us! One of us!

in 🎉Welcome our Newest Community Coach — Elliott Leonard Comment by ArborRose January 23

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…

in Recommendations for connecting to GA4 data through the BigQuery cloud connector? Comment by ArborRose January 21

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

in Why does my Beast Mode concatenation fail when individual elements work? Comment by ArborRose January 20

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";…

in How to call Code Engine functions from a Pro Code Editor asset? Comment by ArborRose January 20

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

in Random 1,000 Multiplier??? Comment by ArborRose January 19

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?

in Why does my Beast Mode concatenation fail when individual elements work? Comment by ArborRose January 19

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…

in Variables no longer carrying over datasets/cards Comment by ArborRose January 14

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.

in Domo Community Declining - Oliver to Blame? Comment by ArborRose January 14

Still water reflects the sky; sunshine gathers on the surface. 🌞

in Domo Community Declining - Oliver to Blame? Comment by ArborRose January 14

Grant answered one question so well it solved three others nearby. Congratulations.

in ☃️December 2025 Community Forum Recap🎁 Comment by ArborRose January 14

When I create support tickets, I receive regular reassurance that nothing has happened.

in Development Changes - Missing Refresh Comment by ArborRose January 13

ArborRose Coach

Comments