Best Of
Re: Access Token Reporting
@DanBrinton building on this theme.
PROPOSAL
Domo should add a field "domo instance" to the "Access Token" Account type.
PROBLEM
An Access Token Account object does not store the instance that the account applies to. That's a bit of a mess b/c access tokens are not useful w/o the instance to point it at. same for a username and password combo.
IMPACT ON EXISTING USERS
Adding the field as an optional parameter would not affect any current implementations.
BENEFITS
currently you can only use Access Token accounts if you hardcode the instance into the name of the account (imagine if you had 50 instances). given that Domo makes renaming accounts somewhat obtuse (in fact the display name and the account name are two separate fields which may or may not match in the DomoJupyter config) it's imperative that we not rely on naming the the account appropriately for knowing which instance an account object is related to.
Re: DataFlow Failed with no usable explanation
👍️thanks David. I was not aware of this option and it is most helpful. thanks again for the quick response.
Re: How can I avoid denominator should not get filtered while calculating the percentage in beast mode
@david_cunningham, Thank you so much. My issue got resolved with your suggestion.
SwapnaE
Re: Color rule based on category %
I was able to make the emojis work !!! Thanks a lot @david_cunningham !! Thanks @ArborRose and @DavidChurchman !
shreeb
Re: Aggregation Issues with Beast Mode Calculation
Thank you both so much! It helped with my little test example. I will work on the larger version next.
Cara
Re: Aggregation Issues with Beast Mode Calculation
@Cara, the answer provided by @JedP is excellent and thorough. I'd just like to add on one bit that I think is helpful.
It's very important to think about where you're applying the aggregation context with case statements, and the order of operations when processing the beast mode.
case when Department = 'Finance' and MONTH(ScheduleDate) = 2 then SUM(TransactionNumber) end
is different from
SUM(case when Department = 'Finance' and MONTH(ScheduleDate) = 2 then TransactionNumber end)
In the first example, the case statement is evaluated after the aggregation takes place.
In the second, the aggregation takes place after the case statement has been evaluated.
These 2 can yield vastly different results depending on how you have your card configured.
Re: MongoDB connector not working with added field
The syntax appears to be correct; all commas and parentheses seem to be used properly. There may be an issue with the usage of $fourteenDaysAgo in the $match stage. In MongoDB, you typically use variables defined within an aggregation pipeline stage using the $$ notation, but here it's used as a string value.
Re: April 2024 Community Forum Highlights
Thanks @anna.yardley! It's been wonderful to collaborate and learn with everyone. We really have a great and welcoming community 😁
@Grant.Stowell & @ArborRose appreciate the kind words!
April 2024 Community Forum Highlights
Hello Domo Community!
How is it already May?! Nonetheless, it’s time to post the April Community highlights. The Community has been growing steady over the course of the last year, and it’s showing! Discussions, posts, and reactions have 4x what we’ve seen in the past. And every single question asked on the Community Forums within the last year has gotten an answer. That is ZERO unanswered questions in the past year! We will be celebrating this accomplishment with the Community in the near future. Stay tuned.
Leaderboard Top 3
This month’s leaderboard is not a shocking list, but we never overlook your efforts! Huge thank you to some of our Community’s KEY members. You are so helpful.
- @GrantSmith 530 points
- @ArborRose 519 points
- @ColemenWilson 382 points
Top 3 Posts
Of the 289 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.
- How to get the first character of a string in domo beast mode analyzer
- Case Statement – 28 days from a specific date?
- Scheduled reports, permissions + PDP
Huge shoutout to the following community members for asking such great questions and finding even better answers: @Jones01 @ColemenWilson @pauljames @david_cunningham @Utz @jessdoe @GrantSmith
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: @Kunal @erikjamesmason @DashboardDude
April Community Member of the Month
@david_cunningham, we have felt your energy since you joined the Community Forums at the beginning of this month! In less than a month, @david_cunningham started from zero points and ranked up to be a Contributor. At this rate, you’ll be a Coach in no time 😉 @david_cunningham, thank you for contributing to the Forums! We’re excited to have you and see what you do next.
Like this post if you've been enjoying the monthly Community highlights. And make sure to welcome and congratulate @david_cunningham in the comments below 🥳
