Best Of
Joins, Appends, Unions examples
Joining data can be difficult to understand and use properly, here are a few examples of good join/appends/unions. Take a look at the example page for examples of data options.
Click here to see the full details on our publicly embedded demo page -
JedP
Variable Example Use Cases
The Domo team has created a few example variable pages to help get your ideas started. Here are a few examples of how to use Variables in Domo, these pages are publicly embedded and have links to the variable set up & sample beast mode codes.
Variables General Example Page -
- Dynamic calculations with dynamic columns - Great for ad hoc analysis.
- Heat Map with dynamic categories - Great for identifying trends in the data.
- "What If" target/benchmark calculator - Provides the user the ability to change the target based on column values.
- Temperature conversions - Quick and easy temperature conversions.
Variables for Period over Period Example Page -
- Custom date range comparison - This allows full comparison between 2 time frames.
- Period over period & Year over Year - This uses pre-defined lookback windows to review the data.
- Dynamic periods - Allows users to swap the axis of a chart between time frames.
- Exclude last month(s) - Great for delayed data like financial data.
JedP
Re: Individual level Alerts
Yes, workflows would be the best solution for this and easier to maintain compared to the potential # of cards you might need to create if you went with card alerts.
Re: Individual level Alerts
There is a new feature called Workflows that could do this for you. I believe it is still in Beta, so you would need to ask your CSM if you can have access to it. Here is a link to the KB article.
If that isn't possible, you could set up multiple cards that have alerts tied to them and would be filtered to the specific employee and then other cards for the manager with a separate criteria.
Re: Window function beastmode error-ing
I would check to see if any of your column names changed recently. I also wonder if you really want the NULLIF in there or not. Do you want to potentially divide NULL by 12? Or even 0 divided by 12? You may want to re-visit that portion of your logic.
September 2023 Community Forum Highlights
Hello Domo Community! 👋
Another outstanding month has come and gone for the forums! Every day, we see new faces on the forum asking intricate questions and you all show up to bring them the answers. This month's average time to answer was 21 minutes, which is ⚡️lightning⚡️ fast when compared to the three-hour industry standard. Here are some highlights to show just how amazing you all are!
Leader Board's Top 3
The Domo Community Forum Coaches have struck yet again! These top three users are competing for leaderboard face each month. We’re excited to see some new users climbing and giving them a run for their money. Congrats and thank you to these three who have collectively answered 113 questions this month.
- @GrantSmith- 955 points
- @ColemenWilson- 571 points
- @MichelleH- 476 points
Top Posts
With the many discussions happening each day, these ones stood out as some of the most active. Follow the links and show these users kuddos by leaving them a reaction.
- Any way to highlight current date on a line chart?
- Drill Path - working in Edit Drill path, not working in pages
- How do I remove the 'Total' row from a data import?
- Beast Mode Formula is not working as expected
Huge shoutout to the following users for asking such great questions and finding even better answers: @Laura_M1, @MichelleH, @ColemenWilson, @dkonig, @swagner, @jtrollinger, @MarkSnodgrass, @marcel_luthi, @Tung, @GrantSmith
Top Ideas
The Domo product is always improving because of your ideas. Below are the top voted ideas. Go and give some additional upvotes to the ideas you think deserve to be implemented into Domo.
- Auto Height and Width For Cards
- Dimensions Calendar Update
- Analyzer Date Range Update
- Ability to remove unnecessary columns directly in the input DataSet before loading all its rows
Congrats to these users for coming up with innovative ideas: @Support, @sevans_ate_9, @Fabio Ferragina
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 Coaches
September brought us two new coaches to join the ranks! As we continually mention, hitting coach status is a huge milestone in the community member’s journey. These individuals have shown us what it takes to achieve greatness and motivate us to be like them!
Community Member of the Month
Well, we all saw this one coming. It wasn’t a question of if Grant Smith would be the CMM at some point, but when! Every month since we started doing the community highlights, Grant Smith has been at the top of the leader board. The number of questions Grant answers in a single month is greater than most will answer in a lifetime. In the month of September, he answered 79 questions and 54 of them were accepted as ‘best answer.’ If there were a Domo Hall of Fame, Grant’s face would be plastered on every wall. Give him a shoutout in the comments below to let him know just how awesome he is!
