Best Of
Re: Appends Should Default to Include All Rows
@trafalger Got it! This is definitely on my radar and something I'm exploring with the team. :)
Re: Undo button in Magic ETL
Just wanted to update you - development for this is in progress and we're aiming for a beta in May or June.
March 2024 Community Forum Highlights
March was an amazing (maybe even the best?) month for the Community! We got to meet with so many of you in person at Domopalooza. Community members had several opportunities to network as they attended breakout sessions, roundtables, concerts, and even Ski Day! Of course (with no bias 😉), the best part of the conference had to be the live Domo Demo Slam, where MarkSnodgrass was crowned victor!
If you missed Domopalooza or want to rewatch a session, they will soon be published in the Domopalooza Resource Library! That way you can experience all the amazing knowledge and insights shared during the conference.
Domopalooza wasn’t the only thing that made March a special month. We also saw some monumental achievements in the forum, so now it’s time to give you the recognition you deserve.
Leaderboard Top 3
First things first, we need to acknowledge our top three community members of the month. We are just as pleasantly surprised as you to see a new face placed at number one! @ArborRose came out of left field last month and flooded the forum with answers. He already impressed us when he became a community coach and CMM in the same month, but he still hasn’t let his foot off the gas! Joining ArborRose on the leaderboard are @GrantSmith and @MarkSnodgrass, who also deserve our heartfelt respect for showing up for our community. Thank you for your hard work and for answering the community’s questions.
- @ArborRose: 859 points
- @GrantSmith: 646 points
- @MarkSnodgrass: 385 points
Top 3 Posts
Of the many discussions happening each day, these stood out as some of the best. Follow the links and show these community members some love by leaving them a reaction.
- Beast mode CASE calculation for number ranges that have null values in column.
- Average question
- How to calculate a percentage based on another beastmode
Huge shoutout to the following community members for asking such great questions and finding even better answers: @art_in_sky, @marcel_luthi, @Jones01, @shreeyab, @MichelleH, @ArborRose, @nickcorona
Top 3 Ideas
The Domo product is always improving because of your ideas. Below are the ones that got the most votes. Click the links below and give these ideas additional upvotes to increase their chances of getting implemented into Domo.
Congrats to these community members for coming up with innovative ideas: @SherryR, @Jemiller , @trafalger
Newest Contributors
Climbing the ranks is never easy, but these newest contributors certainly made it appear so. Congratulations to our newest Contributors—we’ve got our eyes on you.
Newest Coach
On top of having two new contributors join the community ranks, we also got a new coach last month. John Le, also known as the @DashboardDude, has done so much for our community over the years and has essentially been a coach in every way except in name—until now! Thank you, John, for your continued support. We truly feel spoiled to have you as a member of our community.
Community Member of the Month (CMM)
Our CMM for March is a seasoned Domo pro. To put it frankly, mere words can’t express just how important he is to our community. @MarkSnodgrass has been around the Community Forums for years. He has his own YouTube channel, @MarkOnDomo, dedicated to helping users learn how to use Domo. He frequently shows up on the leaderboard every month and is ranked number two on the all-time leaderboard with a whopping 11k points. This month, Mark answered _ questions with _ of them receiving best answer and as mentioned before, he won the live Domo Demo Slam at Domopalooza. It’s clear to see why Mark holds a big place in our community’s heart, so be sure to give him a big CONGRAGULATIONS in the comments below! He’s earned it.
Re: How to get 2 decimal places only
Try:
CONCAT(ROUND(Sum(CASE WHEN `To Step` = 'Forward to HM' THEN 1 ELSE 0 END)/(COUNT(DISTINCT `Requisition Number`)),2), ':', ROUND(Sum(CASE WHEN `To Step` = 'Hire' THEN 1 ELSE 0 END)/(COUNT(DISTINCT `Requisition Number`)),2))
Re: Templated ETLs
I love this idea! It's similar to another idea I've heard, which is to be able to save snippets of Magic ETL DataFlows as "recipes" for use in other DataFlows. These are things that my team is actively reviewing.
Re: Help with SQL query
Domo did announce at Domopalooza a new Beta for an ON clause in Magic ETL join tiles you might find helpful and valuable. You can read up on it here:
Re: routing ETL failures through zapier
You may want to look into this video by @ellibot




