Best Of
Re: Filtering Question
I didn't think that would work because text and number fields usually don't work well together. But it did! Thanks everyone for the ideas!
ARosser
Heatmaps are some of my long time favorites....
So I have been meaning to post this for a while. And many here know I am very passionate about up leveling how we communicate new feature releases for Domo with our customers and our user community. While we have made huge strides, there are still some small things that sometimes sneak out without the formal release fanfare (which I was reminded of this again reviewing content for our upcoming customer release in 2 weeks!).
And well, heatmap cards have long been some of my favorite to use in Domo and we recently (or in the last couple months) added two cool setting for the Heatmap card type in Domo (note this is different than the Heatmap table type and is under Other or Popular Charts):
1) Add a total row and/or column (without having to pre calc a ton of things)
2) Set how many series you want to show (before if you used top X rows it would show 5 values not the first 5 set of data)See below for example showing the legacy view and then tabs showing the totals and Adding Top 5)
Screenshots attached and you can also go ahead and see how it works in this Domo App Studio App:
Have fun!
Re: App Studio - Move/Copy Card Functionality
Adding onto this - it will also allow for cards in app studio to sync with cards outside of app studio. I have an app that has a card, but it also exists on a dashboard that is exported as a report. It would be nice not to have to change both, but link them.
Re: Solution: Beast Mode & Pivot Table Aggregation Error
Hello @abarrie23 ,
I think i see the issue here, it looks like you are mixing your aggregations in your case statement.
The THEN result appears to just be a non aggregated column, while the ELSE results in a Window function aggregation. When you mix aggregation results and non aggregation results you end up with multiple results which is what causes the issue.
To correct the issue, you will need to re-design your code to ensure that the results are all the same level. And it can be hard to say what will work without knowing the data structure, but if i had to guess, you might be able to add an aggregation to your THEN statement to get the aggregations to align. So depending on your datasetup, I would suggest trying a SUM or a MAX or MIN around your THEN statement.
CASE
when Term Length (Months) > 0 then MAX(Term Length (Months))
else
SUM(SUM(Term length (lookup)) FIXED (BY Document Number))
END
JedP
Re: Comment out tiles in MagicETL
A Comment Box to document the subpart of complex ETLs would be great for now addition to Comment out tiles. For reference, here's what they have in Alteryx.
g_bag
Re: Comment out tiles in MagicETL
This is an idea I've been deeply interested in as well, as a heavy Magic user myself. I do have it on my backlog, but with this additional signal, I will review this with the team again. Thank you for surfacing this!
I have a lot of ideas along this vein, including better commenting in general, grouping/boxing of tiles together, markup on the canvas etc.
Re: Comment out tiles in MagicETL
PLEASE!!! For the love of all you hold dear, Domo…Please give us this! It's been requested for many years and is standard in any coding that's done. Doesn't seem to make sense that this capability is lacking.
Re: Stacked Bar Chart with Line Graph
I'm not sure if I understand the question. Does this help?
Year | Outcome | Type | Count |
|---|---|---|---|
2023 | Win | Retain | 50 |
2023 | Win | Capture | 30 |
2023 | Loss | Retain | 20 |
2023 | Loss | Capture | 15 |
2024 | Win | Retain | 60 |
2024 | Win | Capture | 35 |
2024 | Loss | Retain | 25 |
2024 | Loss | Capture | 10 |
outcome and type:
CONCAT(Outcome, ' - ', Type)
retain:
SUM(CASE WHEN `Type` = 'Retain' THEN `Count` ELSE 0 END)
wins:
SUM(CASE WHEN `Outcome` = 'Win' THEN `Count` ELSE 0 END)
August Community Highlights 🏫🎨✈️: Tell us where you've traveled to this summer!
Hello Domo Community!
Happy back to school and back to work for any families out there. Despite summer travel the last few months, the Community has remained as active and helpful as ever.
If you've traveled this summer, I want to know! Please share in the comments so we can all get a little jealous.
Now time to recap the Community Forums most engaged posts and users in August. Follow the discussion, ideas, and user links to contribute to August's hot content 🔥
Newest Community Update: Community Gallery!
Our Community members are some of Domo's most innovative experts. We're so excited to finally share Domo's Community Gallery: a video gallery to showcase how Innovators are using Domo to solve their unique use cases. This is just the beginning, we will constantly be adding new videos, so bookmark the Gallery if you find it helpful.
If you have any feedback on how we can improve the gallery, I'd love to hear it. Please direct message me.
Leaderboard Top 3
This is the EXACT same leaderboard finish as last month! Looks like we've got some good competition happening. Huge thank you to @ArborRose, @GrantSmith, @ColemenWilson!
- @ArborRose 703 points
- @GrantSmith 416 points
- @ColemenWilson 283 points
Top 3 Posts
Of the hundreds of discussions that were had in August, 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: @ArborRose @miguel_bustamante @Manasi_Panov @JasonKerr @DavidChurchman @Kanokkarn @Sean_Tully
Top 3 Ideas
The Domo product is always improving because of your ideas. Of the 50+ ideas added in May, the following three got the most votes. Click the links below and give these ideas additional upvotes to increase their chances of getting implemented into Domo. Over 30 ideas from the Ideas Exchange have made it into the product in 2024!
Congrats to these community members for coming up with innovative ideas: @KMoore @Edgar_Movius @ColemenWilson
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
- @LaurenLacy, Contributor
- @Edgar_Movius, Contributor
- @Manasi_Panov, Contributor
Ranking up is not possible unless you are helping users by answering questions. Thank you and congrats to you three! @Sean_Tully, we see you 👀 Super close to hitting Coach, maybe within the next month or two 😉
August Community Member of the Month: @Manasi_Panov
@Manasi_Panov has come to the Forums (not just to find answers, but) to help many users this month. @Manasi_Panov has gotten great feedback in reactions and accepted answers, which all added up to ranking up to Contributor this month! We're so happy to see another face sharing their knowledge with the Domo Community. Thank you @Manasi_Panov!
Like this post if you've been enjoying the monthly Community highlights. And make sure to congratulate @Manasi_Panov in the comments below 🥳
