Best Of
Re: Creating a Running Percentage Chart
I don't believe so. Without some of the windowing functions of SQL, you won't have dynamic logic in FIXED expressions. I played a little and got close but did not get a running total. It used a value at each date not accumulated over time. You are going to have to create an ETL because of the aggregation needed.
Re: Please provide Dataset Watchdog Custom Query examples on documentation page
Interesting….yes, it appears that Domo should make some additions to the support page.
I would assume the queries have a single dataset limitation. Domo dataflows use MySQL syntax, so try that rather than MS SQL syntax. Use backtick as common practice for calling out datasets or fields. I recall that working for me. I've seen posts mentioned joins failing. That's why I think you have to stick with a single dataset. I also don't think you can use any kind of function in the query.
Try things like
SELECT *
FROM `Customer Records`
WHERE `Email` IS NULL OR `Phone` IS NULL
SELECT `Product`, SUM(`Sales`) AS `Total Sales`
FROM `Weekly Sales`
WHERE `Date` >= CURRENT_DATE - INTERVAL 7 DAY
GROUP BY `Product`
ORDER BY `Total Sales` DESC
LIMIT 10 SELECT * FROM `12345678-90ab-cdef-1234-567890abcdef`
In that last example, this would be if you can call the dataset from it's id rather than its name. Grab the id from the URL when you look at a dataset.
We Want to Hear From You! What Webinar Topics Interest You?
Hi Domo Community!
We’re excited to announce that we’re gearing up to get our ACE webinar series rolling again, just like we used to! Before we start building out the schedule, we want to make sure we’re creating content that’s valuable and relevant to YOU.
What topics would you like to see covered in upcoming webinars? Whether it’s deep dives into specific Domo features, best practices for Agentic AI, building apps, tips for optimizing workflows, or something else entirely — we want to hear your ideas!
Please drop your suggestions below. Your input will help shape a webinar lineup that truly supports your learning and growth with Domo.
Looking forward to your feedback!
Thanks,
Dan Hendriksen
Director, Advanced Customer Enablement (ACE)
Re: Magic ETL Field Search Tile Highlight Enhacement
I added my upvote, but also had submitted a very similar suggestion back in February.
jimsteph
Re: Integrating Microsoft Teams with Domo Alerts
I think this would be a great feature and enhance Domo's integration with other industry standard platforms.
Add Forecasting with AI button is not available
Hi everyone,
We just started exploring the universal forecasting models here in domo and we are experiencing a few obstacles in the early stage.
I created a dummy app to test the feature with a simple curved line card using fields with a date and integer data types, but the "Add Forecasting with AI" button on the right pane under "Edit in Analyzer" does not exist. Am I missing anything?
Thanks.
rmbourne
Re: Creating BeastMode to Identify Freemail Users Using LARGE list of Freemail Domains
Am I to understand that you are trying to extract email addresses from a single column that has a huge amount of text and contains ALL your email addresses and their domains? If so, ouch.
And then…you are trying to compare each value to a list of known freemail domains and flag whether the domain is freemail or business?
CASE
WHEN `emaildomain` IN ('gmail.com', 'yahoo.com', 'hotmail.com')
OR `emaildomain` IN ('aol.com', 'icloud.com', 'outlook.com')
OR `emaildomain` IN ('mail.com', 'zoho.com')
THEN 'Freemail'
ELSE 'Business'
END
Re: Not able to open Magic ETL
I recommend reaching out to your instance admin to verify that you have the correct role/grants to use MagicETL
