Best Of
Re: Dataset Scheduling Customization Options
I had no idea a Domo API existed for use on a database rather than their domain, that's a game changer. Thank you for the help :)
Re: Splitting Appointments
Here's a break down of the way I was thinking. Apologies my docking unit just died and I have no monitors. I'm not used to using a laptop screen…lol..
AppointmentID,AppointmentDate,Provider,Metric
1,2024-06-15,Mitch,1
2,2024-07-20,Justin,1
3,2024-08-05,Kristin,1
4,2025-01-10,Kristin,1
5,2025-02-22,Kristin,1
6,2025-03-15,Justin,1
7,2025-04-12,Mitch,1
8,2025-05-30,Kristin,1
Provider,Galley,SplitPct,StartDate,EndDate
Mitch,John,1,1900-01-01,9999-12-31
Justin,John,1,1900-01-01,9999-12-31
Kristin,Tanner,1,1900-01-01,2024-12-31
Kristin,Tanner,0.5,2025-01-01,9999-12-31
Kristin,Brent,0.5,2025-01-01,9999-12-31
Using a Magic ETL to join the mapping to the appointments over time and applying a formula to adjust the split (sorry my naming is not good). You would come out with
which is similar to Colemen's comments.
Re: Error Loading Form - App Won't Load for users
Ooooohhh, that makes sense. Thank you!
Except, I'm trying to use it as an intake form for something so they wouldn't have access to the dataset yet. They might not even be a Domo user yet. My question may need to be a new thread, I'm just thinking out loud. 😊
Cfunk
Re: Deploying Snowflake - MagicETL as a MySQL export?
Andrew Chaffin at Argo Analytics has a solution that exports out ETLs and converts them to SQL. You may want to reach out to him.
Re: Dynamically retrieve dashboard where card is saved
Brilliant! I got the above Beast Mode to work and used a Page filter to manage. Thank you @DavidChurchman!!
Re: Dynamically retrieve dashboard where card is saved
Try the 'Pages and Cards' report from the 'Domo Governance' datasets. That has the Page ID, Page Title, and Card ID of every page in your instance. From that, you could create a BeastMode that has the URL of every page. Then, you could use a card filter for whatever page you're on, so it only shows the URL for the current page.
CONCAT('<a href="mailto:abc@gmail.com? subject=Help!
&body =
Dashboard link: https://companyabc.domo.com/page/' , `Page ID`, '
">',
'abc@gmail .com','</a>')
You could also create card-specific links.
Re: How can I get null/empty string fields to appear as zeros in my ETL?
Hi Devon, the value mapper worked! I'm not sure why the formulas didn't work. Thank you for the tip!
levi_kim
Re: Forcing Alerts on Users?
You should be able to use a condition such as
If % Planned < 70 OR % Planned > 95
And add the resource manager as a subscriber. If you need a guaranteed weekly digest (not just triggered when someone slips out of range), set up a weekly scheduled report of the same card.
Re: Forcing Alerts on Users?
I would recommend you setup a workflow. Using AI you can probably come up with something more useful than alerts.
If you haven't seen them, there are Domo recordings of recent community events where workflows are demonstrated with AI.
Brag Time!
I just finished my MajorDomo certification!! 🙌🙌🙌🥳
What have you MajorDomos done to communicate the value that this provides, and the skills that it's fostered? I want my firm to understand what this means and how it sets us up for success in the future. Thinking something along thelines of "I'm a MajorDomo now. This means I'm well-equipped to manage, administer, build, deploy, and otherwise ensure the success of our data."
Kind of a weird question, but this is a safe space and y'all are the best anyway 🤷
