Best Of
August 2023 Community Forum Highlights
Hello Domo Community! 👋
August has been a standout month with many new users joining and interacting with the forum. We appreciate everyone’s efforts as you continue to find new and creative solutions to your daily challenges. You put the INTELLIGENCE in BI!
Leader Board's Top 3
Are we really that surprised to see these familiar names on our top 3? Thank you to these exemplary users for answering dozens of questions every month and for being all around amazing! You make our community feel complete.
- @GrantSmith - 773 points
- @colemenwilson - 671 points
- @MichelleH - 316 points
Top 3 Posts
Here are some of the best posts we saw in August. These users had some great questions that were followed up with amazing answers! Follow the links and leave a like for all of your favorites Q’s and A’s.
- Help with a complex calculation that isn't working in Beast Mode. — Domo Community Forum
- Help the Newbie! SQL Connection not working anymore — Domo Community Forum
- DAP Dataflow — Domo Community Forum
Huge shoutout to the following users for asking such great questions and finding even better answers: @Sasha, @MarkSnodgrass, @Jessica, @GrantSmith, @RobB, @trafalger, @colemenwilson, @MichelleH, @Trumpetbob
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.
- New "Domo for Office Add-in" for Excel compatibility with older plugin + having Query functionality — Domo Community Forum
- Customize email address in DataSet via Email Connector — Domo Community Forum
- Freeze top cards (Filter Cards) on a dashboard — Domo Community Forum
- Cookies on Domo Everywhere — Domo Community Forum
Congrats to these users for coming up with innovative ideas: @Pritesh, @colemenwilson, @Kdahl, @joecanning
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 Coach
Becoming a coach on the forum takes hours of time and effort, which is why @colemenwilson deserves all the praise we can give after hitting coach status in just under two months! Go check out this post about Colemen and show him some love by leaving a comment!
Community Member of the Month
This month’s CMM is someone who came out of nowhere and amazed us with their Domo knowledge and expertise. @DavidChurchman gives detailed answers and lots of them. He clearly understands how Domo works and is sharing that expertise with the community in a big way. With 11 questions solved this month alone, he glided into contributor status and made himself known to the community. Congratulations, David, and keep up the good work!
Give DavidChurchman, and any of the other highlighted users a shout out in the comments below.
Re: Select all/none with a filter card
Jumping into an old post here to confirm from a customer conversation today that there is now a feature in Checkbox Selectors that allows Select All or None. Once the filter card is on a page, you will see this a the top of the card
Once that is checked, you can then 'Select none' to uncheck all
Re: Can you use Magic ETL to 'explode' table of transactions to all days?
@M_Gonzalez glad you are enjoying my videos. I think my "Filling in Date Gaps in Domo" would walk you through some of this.
As far the the IFNULL, starting with your rank & window, the name you are assigning for your lag value is what you would be using in your IFNULL along with your main status column. With rank & window tile, you will be creating a new column and you might call it prev_status. Then, in your formula tile, you can fill in the blanks of your main status that exist by writing a formula like this IFNULL(status,prev_status) . This will look at the status column and if it is blank, it will populate it with the prev_status.
I hope this works, but I haven't tested it out fully, but it might get you close to what you need.
Re: Can you use Magic ETL to 'explode' table of transactions to all days?
Here's a rough outline of how you would construct your ETL to do what you want.
Bring in the calendar dataset. I suggest filtering it a bit as it has about 30 years of dates in it. You can use a formula in your filter rule to make it dynamic and not hard-code dates in there.
Get a distinct list of products. I used the group by tile to do this by putting the product name in the select section and then doing any sort of aggregation, such as count of products. You won't use the aggregation. It's just an easy way to get a distinct list.
Add a constants tile to each with a field called JoinKey and value of 1 and then join the two together on that JoinKey column. This will give you a list of dates from the calendar for every product you have. For example, if I filtered my calendar to 2023, I would have 365 rows for Product A, 365 rows for Product B, etc…
Do a Left Join that joins your product/calendar data to your main dataset and join on the date and the product.
Add rank & window tile and use the lag function to get the previous status. Use an offset of 1 and and order by the date field from the calendar dataset and partition by product.
Use the formula tile to do an IFNULL to replace blank statuses with the previous status.
Hope this helps.
Re: Help Pivoting Data
Agreed, I've done dynamic column renaming using a Stored Proc in a MySQL dataflow - you can query the system tables to get the schema.
