Best Of
MAY we interest you in this month's top content?
Most active discussions, users, ideas, and more from May below. Don't skip this one!
AI Event
The AI Academy series is still going strong with incredibly positive feedback. We don't plan on stopping this series anytime soon. If you missed the last couple sessions, the recordings are linked below:
- Episode 3: Automated Data Validation and Smart Routing
- Episode 4: Train your first AI analyst
- Episode 5: Build an agent to analyze and grade transcripts
Agentic AI Summit
This FREE virtual event featured a lineup of AI leaders from organizations like AWS, Domo, Weather Trends International, OneMagnify, CWC Data.AI, Opus, and Community Fibre. They shared how AI agents are transforming businesses and trends that predict where AI is headed next.
Did you miss it? Catch the on-demand session HERE.
Leaderboard Top 3
Thank you @ArborRose @brycec and @DavidChurchman for clearing out the unanswered questions queue and helping users get solutions.
- @ArborRose, 407 points
- @brycec, 165 points
- @DavidChurchman, 114 points
Top Posts
Here the top most viewed and engaged with posts from the last month. Follow the links and leave a reaction if you found them helpful too.
- More Efficient YoY actual than budget view
- Best practice for visual indication that a drill down configured
- Showing profile photo on Sales leaderboard
- Why date filter is not working
- Error fetching results from DomoAI textual analysis app
- Beast Mode for total active tickets per hour
- Smart text date ranges
Shoutout to the following community members for asking and answering our top discussions this month: @Data_Devon @DavidChurchman @GrantSmith @Jay.p @MichelleH @nathankilcrease @amberd @BryantCafferty @ellibot @ArborRose @Abe @Thuy_Tu @JoeS
Top Ideas
The Domo product is always improving because of your ideas. Of the ideas added in April, these five got the most votes. Click the links below and give these ideas additional upvotes to increase their chances of getting implemented into Domo.
- Transpose functionality for HTML tables, 19 upvotes
- App Studio, name length / fitment, 6 upvotes
- App studio tabs, 6 upvotes
Thank you @Sam_Donabedian and @Craig_Lynch for sharing your innovative ideas.
New Rank-ups
@Manasi_Panov, Coach! 🚀
@James Gossling - Bispoke, Contributor
@MattGo, Contributor
@ShaneB, Contributor
@CR-eSobylak, Contributor
@lhrogersiv, Contributor
Contributor = 100 points, Coach = 1000 points. It takes a lot of dedication to earn points and rank-up. Most of their points have be earned by helping users get solutions to their questions. Thank you for all your contributions.
Community Member of the Month, @ArborRose!
@ArborRose is our second-only community member to be a Community Member of the Month TWICE! @ArborRose is consistently at the top of the monthly leaderboard. @ArborRose chose to answer nearly every question on the community in May—what does he not know at this point? Earning 407 points in one month is one of the best we've seen. Thank you @ArborRose for being a key member of the Community.
Let's thank and congratulate @ArborRose in the comments below!
Re: How do I get "smart text" I have added to my card to show in the Excel file when I export?
I concur with @ColemenWilson. The smart text is part of the visual layer in Domo, which doesn't export. Only the table data exports. The obvious work-around would be to include a calculated field in your dataset and include it in the card's data table.
DATE_FORMAT(CURRENT_DATE(), '%Y-%m-%d')
Product APIs Postman Collection
I am launching my Postman collection of the Domo Product APIs to the public. This collection contains most endpoints and has been well documented using Postman's new types feature. I am joining Domo next week as the new MajorDomo and wanted this in the hands of the Domo community ASAP. I'll be working with the product team to get my efforts rolled into the official Domo developer documentation in the coming months. I can't wait to see the incredible ways this gets used!
The Domo Product APIs are the APIs that drive the entire Domo platform behind the scenes. Anything you can do via the user interface in Domo can be done via the Product APIs.
While this Postman collection is extensive, it isn't 100% comprehensive. Some endpoints and possible field values are missing. Most endpoints don't have response examples yet. I plan to continue to update this collection over time. If you fork this collection, you can pull these new updates as they become available to merge into your fork. You can also explore the Product APIs yourself by using a combination of this collection and the developer tools network console in your browser while in Domo. You can learn more about the developer tools in Google Chrome here.
brycec
Re: Schema and Meta Select Tiles
Use case is when you want to edit the schema of a dataset. Here are the steps to use the tile:
- Drag the Schema tile onto the canvas and connect it to an input. This surfaces the schema as a table with the Column Names, Expressions, and Data Types of the input.
- Connect the Schema tile to other Magic tiles like the Formula, the String Operations, and more to revise the schema. The Schema tile introduces a new data type called “Expression”. Use the in-tool documentation in the Formula tile to see details about that data type.
- Once you have your schema exactly as you want it, drag out the Meta Select tile. The Meta Select tile requires two inputs – the last tile in the path of your modified schema, and the original input itself. The Meta Select tile applies the changes made to your schema to the input dynamically.
In this example below, I've added "test." in front of each column name dynamically:
Domo Solutions Webinar Recording: AI Agents Unleashed – Build Your First Agent
This originally APAC-specific event got overwhelmingly positive feedback ,so we're releasing the recording to the broader Community.
Watch the "Build your first AI agent in Domo" session HERE.
The Domo Solutions APAC team brings you a practical hands-on session on building AI Agents in Domo—unlocking the power of automation, intelligence, and seamless communication.
Join Brian Orloff as he walks you through building your first AI Agent— one that blends customer, product, and sales insights to create compelling, persona-driven marketing campaigns. It’s a simple yet incredibly powerful starting point designed to get you hands-on experience.
Whether you’re new to AI or looking to expand your automation capabilities, this session will help you take the first step toward building intelligent, responsive, and scalable AI Agents in Domo.
Re: When using a multi-select filter, can this be used as "AND" logic instead of "OR" logic?
A little clunkier than multi-select on a filter, but you could achieve this with multiple variable controls.
Let's say you want them to be able to select up to 3 Job types, you'd create 3 variables:
- selection_1
- selection_2
- selection_3
Then create a BeastMode that references the variables and use that BeastMode as your card filter, filtering for "Include". Add your 3 variables as controls. Below's a potential BeastMode, though you may want to add in conditions for default text on your variable controls:
CASE
WHEN
(selection_1 is null) OR (Job_Type like concat('%', selection_1, '%') )
AND
(selection_2 is null) OR (Job_Type like concat('%', selection_2, '%') )
AND
(selection_3 is null) OR (Job_Type like concat('%', selection_3, '%') )
THEN 'Include'
ELSE 'Exclude'
END
Re: More Efficient YoY Actual to Budget View
Glad it helped. One note of caution: the problem with using BeastMode rather than ETL to force your data wide is it doesn't actually change structure of the data, just relabels it. Prior year data are still on different rows than current years. So if you try to do anything with your date variable, like filter it or graph-by, you'll lose the prior data, or it won't group in the way you're trying to group.
As a simplified example, this is basically what you're doing now (I think):
Date | Value | BeastMode Month | BeastMode Series |
|---|---|---|---|
1/1/2001 | 10 | January | 2001 |
1/1/2002 | 20 | January | 2002 |
1/1/2003 | 30 | January | 2003 |
1/1/2004 | 40 | January | 2004 |
1/1/2005 | 50 | January | 2005 |
1/1/2006 | 60 | January | 2006 |
1/1/2007 | 70 | January | 2007 |
This is how I'm saying you should restructure your data:
Date | Value | Last Year's Value | Two years ago value |
|---|---|---|---|
1/1/2003 | 30 | 20 | 10 |
1/1/2004 | 40 | 30 | 20 |
1/1/2005 | 50 | 40 | 30 |
1/1/2006 | 60 | 50 | 40 |
1/1/2007 | 70 | 60 | 50 |
The benefit being able to use the date variable in the graph-by and filter without losing the prior years data to compare against it, because it's all on the same row.
Re: More Efficient YoY Actual to Budget View
Hi @Data_Devon - I'd recommend restructuring your data to allow more flexible period over period analysis. I've done a write up here with it: https://community-forums.domo.com/main/discussion/53481/a-more-flexible-way-to-do-period-over-period-comparisons#latest
Re: Filtering of Cards
Hey! I've solved the problem. I figured out that I was adding calculated field at Card level and not at dataset level due to which filter was not working. Now when I have added it on dataset level. Now It's working! Thanks for replying😀
