Best Of
Re: May Community Forum Highlights
@Sean_Tully, has been a total beast! Thanks for supporting the community. 🤝
@david_cunningham, those numbers are criminally high! Might be the most points we've seen anyone earn in a single month. Congrats friend!
![[Deleted User]](https://us.v-cdn.net/6032830/uploads/defaultavatar/nZ5X977MOM3Z6.jpg)
Re: If condition between two columns
case when Fixed Value is not null then "Fixed Contract" when Spot is not null then "Spot Contract" else "Undefined" END
I don't have your actual data, so this is assuming that there is never a time when both "Fixed Value" and "Spot" are both populated, and that you don't have to check any other conditions. I threw in an ELSE to catch other cases.
Re: If condition between two columns
@DanieleSilva You can use the following case statement either in Beast Mode or an ETL formula tile:
case when `Fixed Value` is not null then 'Fixed Contract' when `Spot` is not null then 'Spot' end
Re: GROUP_CONCAT function in Dataset View vs MySQL Dataflow
The "Add Column" group by option for combining strings uses the comma as a separator, but the "Add Formula" option allows you to use the group_concat formula you've already written.
Re: May Community Forum Highlights
Congrats @Sean_Tully ! Love seeing your insightful and helpful comments 😁
Re: Identifying what data came from which connector on a card.
Thanks @Jonathan53891 and @ColemenWilson - won’t get to try these until tomorrow when I am back at my desk. But thank you for the quick response and helpful info. I will come back and post to this tomorrow with an update after I have had a chance to try both of these methods. Thanks again!
Re: Identifying what data came from which connector on a card.
There are a few options for this, all of which we employ at my company.
1. Use field naming conventions. Example: `Salesforce.Account.ID`
2. Use field schema descriptions or tags
Would these work for you? If so I could share more info on them if that's helpful.
Re: Dynamic data comparison
@LearningNinja Why do you want to avoid using the built-in date-range/grain filters provided by Domo?
Based on your question here, I would suggest that you take the following approach.
- Set your default card display date range to current year in Analyzer (this will make the card default to show the current year as you requested above).
2. Set up a beast mode that will classify records as being either in a "Complete Month" or a "Current/Future Month"
CASE WHEN DATE(date_column) <= DATE(LAST_DAY(DATE_SUB(CURRENT_DATE(),INTERVAL 1 MONTH))) then 'Previous Completed Months' else 'Current/Future Months' END
3. Use the page filter options for dates. For example, if you wanted to show the current quarter for completed months, you would select the following. You can see that this excludes June data since June is north completed.
This will let your users select any date range that they want, while excluding rows from incomplete months.
Regarding doing period-over-period comparisons. I would recommend reviewing this excellent video made by @MarkSnodgrass, he lays out a very flexible way to set this up.
May Community Forum Highlights
Hello Domo Community!
It's June! ☀️ Which means it's time to post the May Community Forums highlights. Follow the discussion, ideas, and user links to contribute to May's hot content 🔥
Leaderboard Top 3
We love seeing the monthly competition. @david_cunningham knocked @GrantSmith and @ColemenWilson out of the top spot for the first time in a long time. Huge thank you to all of you!
- @david_cunningham 1.4K points
- @GrantSmith 523 points
- @ColemenWilson 475 points
Top 3 Posts
Of the 303 discussions that were had in April, these three got a lot of 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: @user027702 @MattTheGuru @ArborRose @Zel @david_cunningham @MichelleH @DashboardDude @Jarren
Top 3 Ideas
The Domo product is always improving because of your ideas. Of the 60 ideas posted in May, these three got the most votes. Click the links below and give these ideas additional upvotes to increase their chances of getting implemented into Domo.
- Add True Card View reporting
- Continually show tabs in app based on user attributes
- Make exporting, user comments, and real time collaboration possible within app studio
Congrats to these community members for coming up with innovative ideas: @ellibot @SherryR @thampton10
May Community Member of the Month
@Sean_Tully has shown up in May! @Sean_Tully answered 29 questions this month. Sean has received over 25 positive reactions in May (likes, agrees, insightfuls), so we know @Sean_Tully's content is valued! Thank you for your contributions to the Forums. We're getting excited to add you to our Coach club here soon ✈️
Like this post if you've been enjoying the monthly Community highlights. And make sure to congratulate @Sean_Tully in the comments below 🥳
Re: Why doesn't my Map in DOMO have colors?
I've noticed the issue with "@" someone, when it isn't working I just refresh the page and it usually works at that point. Kind of annoying.
For the ETL you'll need to:
- Bring the data table into Domo (as a webform is probably easiest )
- Join it with your data: