Best Of
June Domo Community Forum Spotlight
Hello Domo Community!
We hope you enjoyed June as much as we did! It was a standout month with many notable community achievements. We would like to highlight some of the outstanding efforts made by some exceptional community members who are going above and beyond in supporting their peers.
Leader Board's Top 3
These individuals have blown us away with the speed and accuracy of their responses. Not only did they respond to the most questions, but they had multiple back and forth conversations with users trying to hash out viable solutions to their challenges. To say they went the extra mile is an understatement. Bravo 👏👏👏
- @GrantSmith- 758 points
- @MichelleH- 558 points
- @colemenwilson- 448 points
Top 3 Posts
With the many discussions happening each day, these ones stood out. Follow the links and show these users some love by leaving them a reaction.
- Question on Domo SQL syntax
- How to create a stacked bar chart?
- How do I only show one legend on a map card?
Huge shoutout to the following users for asking such great questions and finding even better answers: @muahmmad_zaidi, @Lauren_Kerl1, @Aag2023, @MarkSnodgrass, @trafalger, @MichelleH, @GrantSmith, @colemenwilson.
Top 3 Ideas
The Domo product is always improving because of your ideas. Below are the top voted ideas (we had a four-way tie for 3rd place). Go ahead and give some additional upvotes to the ideas you think deserve to be implemented into Domo.
- Campaign App Dataset Usage
- Create Conditional coloring based on a value not displayed in card
- Add SmartText to data label | Add "Views Created" to Dataset Overview Tab | Drill in from Aggregated Column | Re-order Colour Rules
Congrats to these users for coming up with innovative ideas: @mlhancock, @SlickVic, @MichelleH, @rockchalk629, @user084060, @Samuel.
Newest Contributors
Climbing the ranks is never easy, but these users certainly made it appear so. Congratulations to our newest Contributors -- we've got our eyes on you.
Community Member of the Month
When selecting the CMM for June, there was one clear winner. @colemenwilson climbed faster than anyone we've seen -- he went from Member to Contributor in a matter of just a couple of weeks. In one month, he made over 60 comments and racked up an astounding 448 points. If you asked a question on the forum, chances are pretty high that colemenwilson was there with an answer. Huge shoutout and a round of applause! 🎉👏👏👏🎉
Help us recognize your peers by leaving a comment below!
Re: how to define full quarters
Okay is the total engagements field populated every day during the duration of the campaign? If so, this is how I did it:
ETL overview:
Step 1:
Add Quarter and Year if not already in your data
Step 2:
Use 2 group by tiles to get the minimum date and maximum date for each campaign within each quarter. Minimum is shown below. Maximum is the same except you choose 'Maximum' as the aggregation type instead of minimum.
Step 3:
Join the data so that for each row you have the minimum and maximum dates
Step 4:
Create a field using the formula tile:
CASE
-- Q1
WHEN Quarter = 1 AND DAY(Minimum Date) = 1 AND DAY(Maximum Date) = 31 THEN 'Full Quarter'
-- Q2
WHEN Quarter = 2 AND DAY(Minimum Date) = 1 AND DAY(Maximum Date) = 30 THEN 'Full Quarter'
-- Q3
WHEN Quarter = 3 AND DAY(Minimum Date) = 1 AND DAY(Maximum Date) = 30 THEN 'Full Quarter'
-- Q4
WHEN Quarter = 4 AND DAY(Minimum Date) = 1 AND DAY(Maximum Date) = 31 THEN 'Full Quarter'
ELSE 'Partial Quarter' END
Step 5:
Join this data back to your base data
Step 6:
Filter out 'Partial Quarter' in your card
This is what the data would look like for reference:
To be able to filter in the Webform while in edit mode.
We have been using the Webform for making edits in our PO quantity so when there are multiple lines it becomes a tedious task of scrolling all the way down or up for editing. The work around for this would be a creating a row with unique ID but still there is a lot of scrolling. A filtering option through columns while editing would be great and user friendly.
Drill in from Aggregated Column
Currently if you have a table card that only shows aggregated values (eg a count of records or sum of values) your drill path will filter to the aggregated value instead of records related to the field that is aggregated.
It would be great to have the drill path filter to the records related to the aggregated value, i.e. if the aggregation is a count it shows the records that are being counted.
rockchalk629
Auto-Collapse all Subtotal Rows
It would be great if there was an option to auto-collapse all subtotal rows. Sometimes there's so many of them where doing it manually isn't really an option, plus any new rows would appear without being collapsed.
trafalger
Add "Views Created" to Dataset Overview Tab
It's currently difficult to identify whether a dataset is used to power any Dataset Views without viewing its Lineage, which is not always convenient with a complex pipeline. This can cause problems when users unknowingly disrupt downstream views because it isn't obvious that there are views of the dataset they're updating. As a minimum, it would be helpful to add a "Views Created" box to the Overview tab of the dataset to make these views easier to find.
Re-order Colour Rules
Hi,
Colour rules are applied from Top to Bottom, which is great until you realise you want to add something that shouldn't override your other colour rules, and so needs to be added to the top of the list as you cannot reorder the colour rules. It would be great if there was functionality to drag the order of colour rules around.
Best,
Sam
Samuel.
RE-ARRANGING OF FILTERS AT THE PAGE LEVEL
Currently we need to delete all the filters again to re-arrange at the page level but we are looking for an option where we can drag and drop the filters instead of deleting filters just to sort the filter order
Create Conditional coloring based on a value not displayed in card
All details are summarized here:
user084060