Best Of
Re: Sum distinct
Using the example data you provided I am getting a deduped SUM of 1,600 using the beast mode I provided earlier, if I add a total row it also evaluates to 1,600. Not sure why it isn't working for you.
Going back to my earlier question, I'm curious what your DAX calculation would evaluate to if you were to add a Product D that has a quantity of 300, 500, or 800?
Re: Finding the total data volume queried and storage amount in GB, TB
You could use the Domostats datset "DataSets History". It has a field called 'Bytes Inserted'.
October Community Recap 👻
Hi Domo Community!
Happy November!! October was a great month on the Forums, skim the below to see the top highlights. Click on the discussions, ideas, and user links and leave comments/reactions to contribute to October's top content 🔥
Latest release: Domo AI Chat
Probably the most exciting thing that happened in October was the greatly-anticipated AI Chat in Domo! Read Domo's SVP of Product, Ben Schein's post about this update to learn more. Additionally, we hosted four new AI livestreams – three of which happened this week. Watch the recordings HERE and view the upcoming events HERE.
Leaderboard Top 3
Huge thank you to @ArborRose, @ColemenWilson, and @MarkSnodgrass for all their help last month (and always). These three earned more points this month (in total) than any months past! It was a super engaged October with lots of questions and points to earn.
- @ArborRose, 653 points
- @ColemenWilson 636 points
- @MarkSnodgrass, 356 points
Top 3 Posts
Of the hundreds of discussions that were had in October, these three got the most views and engagement. Follow the links and leave a reaction if you found them helpful too.
Shoutout to the following community members for asking and answering our top discussions this month: @ArborRose @MarkSnodgrass @ggenovese @Izham @ColemenWilson @GrantSmith @user060355 @Manasi_Panov @TimD
Top 3 Ideas
The Domo product is always improving because of your ideas. Of the 50+ ideas added in October, these two 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: @sopche03 and @pimogo
Reminder: Our product managers are amazing and deeply care about your feedback. They regularly review your top-voted ideas and consider them for the roadmap. However, implementing all the ideas is not feasible. Check the idea status highlighted in yellow if you'd like an update.
New Rank-ups 🚀
- @bdetcher, Contributor
- @kensie_rowell, Contributor
- @RabidCougar, Contributor
- @kelly_tagtow, Contributor
Users rank up as they answer questions, get positive reactions, and engage with other users. Thank you to you four who have dedicated time contributing to the community.
October Community Member of the Month: @ColemenWilson
Congrats to @ColemenWilson who is our first-ever second-time Community Member of the Month! @ColemenWilson was recognized in June of 2023 when he first joined the Community and started answering questions like crazy. Since then, he's continually been at the top of the monthly leaderboard from answering your questions. The community really wouldn't be the same without @ColemenWilson. THANK YOU!!
Please let me know in the comments if you enjoy these posts or if there are any other stats/activity data points you'd like to see included in these posts.
Re: Support for Emojis in Dashboard Names
Yes this is really annoying - would love to be able to use emojis in my dashboards
Re: A way to see cards housed in app pages
UPDATE: Found a way with the help of our Domo Admin. You can join two Domostats: Cards, and App Studio App Pages. Page ID is in both datasets.
Re: Connect to Azure SQL DB using AAD/MS Entra user
One way you can connect your Azure SQL database to Domo is through Domo Workbench. You can create an ODBC connection to your database and then use that connection in Workbench. Workbench allows for a lot of scheduling options and transfers the data securely.
https://domo-support.domo.com/s/article/360056669354?language=en_US
Re: Error with String to Date
there's a FUZZY_PARSE_DATE() function in Magic ETL, I tested with the string '/3/31/24/' and it converted it to date without an error
Re: Removing 'Powered by Domo' mark when embedded.
Gotcha! With a card embed it is not possible to remove the "Powered by Domo" but you could make a single card dashboard and embed that and that would remove the "Powered by Domo".
Join the Community at Domopalooza 2025 🪅🤝 Now open for registration!
The wait is over—Domopalooza 2025 is here, and this year, it’s bigger and bolder than ever. Domopalooza is the ultimate Data + AI conference, where the brightest minds come together to share, learn, and have a whole lot of fun.
Here’s a sneak peek:
- Brilliant minds (that’s you!) coming together for an explosion of insights.
- Workshops and success stories so good, you’ll want to take notes in ALL CAPS.
- Concerts, parties, and...
REGISTER NOW HERE.
And here’s the best part—if you register now, you’ll save $200 with our Early Bird pricing—because we believe in rewarding early action-takers.
Experience the collective brilliance of the Domo community for yourself in Salt Lake City, March 18–21, 2025. Bring your thinking cap, your party shoes, and maybe a pair of skis. See you on the slopes—and in the sessions!
Learn more about Domopalooza here.
Re: MTD, MTD Last Year Beastmodes do not work properly with Date filter
Variables are pretty awesome, especially for the sort of reporting you're doing where there are a fixed set of months that will never have to change and a limited number of years that need to be updated infrequently.
Regarding your questions:
- You can update the years at any time
- What I sent earlier assumed a month number, but I can see how a name works better for the variable. I'd suggest populating it with month names and then update the beast modes with
<month variable name> = MONTHNAME(<your date field>)
3. the Default Value can't be an expression unfortunately, but you could add a month to your variable called 'Current Month' and then have your beast mode handle it that way
4. YTD/YTD Last Year would require and update to the filtering beast mode, so that it returns full years rather that specific month and years. One way to handle it would be to update the beast mode if you think your users are going to be selecting years often. But another way to handle it would be to just save your card with Last Two Years selected as the date range, going this route would eliminate the need for the Year variable.