Best Of
Re: Multi Levels Sankey
What kind of witchcraft is this? I never knew we had this ability. Bravo you two. I shall be investigating this.
Re: How to find recording for pass forum?
thank you everyone..finally i can access the recording…
Re: Domo Office Add-In: Excel rows not updating in Domo
Domo's documentation on the Office Add-ins mentions a need to clear your Microsoft cache if you do not see data.
Make sure your authentication token hasn't expired. Try logging out and sign back in to refresh the connection. If the add-in has an option for replace or append, you might try appending to see if there's connectivity.
If you check the schema, does it show column names and data types, but no rows exist? Is this a new dataset or previously used dataset?
Re: Searching by Graph type in my instance
@MichelleH @SEC you can actually create your own DomoStats dataset to show chart types using the JSON no code connector. Here's a tutorial on how to do it: https://www.youtube.com/watch?v=4_Jo_S4bvzs
ellibot
Re: Variables - where can I manage/view all in my instance?
Posted in the Idea exchange here:
swagner
Re: Beast Mode- SQL code to count how many updates in 6 hour intervals
Hi @Abe ,
Feel free to book some time and we can see what we can do: https://www.dashboarddudes.com/domo-help
Re: Needing ideas on a way for users to "build" their own form using choices
I like using Domo bricks, but you could do it in App Studio. Create a couple datasets.
Start with predefined options (dataset 1) such as
Name, Category, Price, Description
Sunroof, Exterior, 1200, Open air roof
Leather Seats, 2100, Genuine leather fabric
Alloy Wheels, Exterior, 1200, 18" alloy wheels
Roof Rack, Exterior, 800, Removable roof rack
Premium Sound, Interior, 600, Surround sound system
And custom options the user submits
User ID, Name, Price, Timestamp
1001, User A, Custom Paint Job, 2500, Special red from 80s model, 2025-05-07 14:28:00
1002, User B, Dog Seat Cover, 120, Pet-safe, waterproof, 2025-05-07 14:32:00
1003, User B, Rear View Camera Upgrade, 350, Higher resolution aftermarket, 2025-05-08 15:12:42
After the user fills out the form with their choices, use an ETL to pull prices from dataset 1 for selected options, and dataset 2 for custom selections. Combine all into a total price and display a quote with all items line-by-line and a total.
Create the application with checkboxes, dropdowns, and free-form text inputs. Allow users to select predefined items from dataset 1, and add input fields for custom add-ins and the price. Write the inputs back to dataset. Store the form submissions in a dataset.
Calculations and Aggregation Logic - use magic ETL and/or beast mode calcuation to join the selected options with their prices. Combine the custom items and prices. Sum up the total. Use a card or dashboard to show the selected items with breakdowns, custom add-ons, final price. Download a quote as a PDF.
- User opens dashboard → sees form with predefined accessories.
- Selects checkboxes/dropdowns for options.
- Enters custom add-on name + price.
- Clicks “Submit” → data is saved in writeback dataset.
- ETL or Beast Mode calculates total → dashboard updates.
- PDF quote download (optional).
Re: Multi-line Chart - Looking for filtered AVGs with Overall AVGs
You would want to create a beast mode that calculates the overall average and put that value in your series. You would want to use the Fixed Functions feature to calculate the overall average. This KB article walks you through it.
https://domo-support.domo.com/s/article/4408174643607?language=en_US
