Best Of
Re: ETL Process to Analyze Google Reviews and Generate Automated Replies
Yes this can be done using DomoGPT in a Jupyter Workspace. If you come to Domopalooza, you can hear @nathankilcrease explain how this is done. He may even be willing to help out sooner than that if you ask him very nicely and offer him some legos.
Re: How to remove all grid lines except for X & Y zero lines
Ty @ColemenWilson!!
GOAT status approved 💯💯💯
New Formula Functions in Magic ETL
Hi friends,
Just a quick post here to let you know about a couple new formula functions that have been added to the Magic formula editor. Not a big enough thing to warrant its own product release, but just a little note here to let you know about them:
- ROW_NUMBER(), which would normally be used with an OVER clause, can now be used without an OVER clause in the Add Formula, Group By, and Filter Rows tiles. It evaluates to an incrementing integer beginning with 1 for each incoming row to the tile. It is especially useful for working with data where the original order is important but there is not a column that contains a value that could be sorted on.
- DATE() can now be invoked with three integer arguments, the year, month, and day. So to get the 15th of the month of an existing date
d, you could write:date(year(d), month(d), 15), which is more elegant than concatenating together a string and parsing it with STR_TO_DATE. (Don't even pretend you've never done that, I've seen what you do…)
Let me know if you have any questions!
Take care,
Your Friendly Neighborhood Magic ETL Product Manager
Re: How do we hide/merge duplicate cells in a column in HTML table
Currently this isn't an option with the HTML table, I'd recommend adding this as an idea to the idea exchange.
Re: Remove Duplicate rows in Card
Hi @Abhigyan,
If it's a table card you're building, then I would recommend adding an aggregate column to the card (e.g. a COUNT or SUM). This should condense the duplicates. Then you can hide the aggregate column by going into Chart Properties > General > Hide Columns and typing the corresponding column number (If you want to hide the third column from the left, then enter 3).
Hope this helps!
Re: Omitting rows in pivot table
You can't truly omit those rows and still show the total, but you can click the minus sign next to 2021 which will collapse those rows keep the detail from showing. If you do this in analyzer, it will save as the default setting for the viewer of the card.
December Community Recap
Hi Domo Community!
It was an exciting December and I hope each of you are ready for a new year! Check out our December recap, as well as this month's CMM. Feel free to like, agree, upvote, and comment on discussions you find helpful. Postitive reactions give points to the author to help them rank up.
Catch up on the latest AI & Hands-On Livestreams
- Experience the Power of AI Agents
- Domo Hands-On: Editable Data: Work Lists, Annotations, Approvals, and More
View the upcoming events HERE.
Leaderboard Top 3
A stacked leaderboard! Thank you for all the assistance and Community help last month (and always).
- @ColemenWilson, 323 points
- @ArborRose, 254 points
- @GrantSmith, 186 points
Top 3 Posts
These three questions had the most views and engagement in December. Follow the links and leave a reaction if you found them helpful too.
- Text Column as values in Pivot Table
- BeastMode That Filters
- Showing Events that Happen after a Selected One
Shoutout to the following community members for asking and answering our top discussions this month: @0RNGL4DY, @ColinHaze, @art_in_sky, @ColemenWilson
Top 3 Ideas
The Domo product is always improving because of your ideas. Of the 35+ ideas added in December. 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: @MasonW
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 🚀
- @art_in_sky, Contributor!
Users rank up as they answer questions, get positive reactions, and engage with other users. Thank you to you four who have dedicated time contributing to the community.
December Community Member of the Month: @Data_Devon
@Data_Devon has jumped onto the scene since May and has accumulated a ton of community cred. Although new to the BI & Analytics space he has climbed the leaderboard by being active each week. Not only did you provided a "sliver of value" (his words), you provided the entire pie this month! Huge thanks for all you do for the Domo Community!
Are there any other data points you'd like to see me include in these monthly posts? Let me know in the comments below 👇
Re: December Community Recap
A deep honor!! 🤝
I'd like to thank my dog for always encouraging me, my ergonomic mouse with side-scroll functionality that lets me easily get to the 329th column, and my team for their outlandish requests that always require new skills to be obtained in Domo.
Onward!! ⛷️⛷️⛷️⛷️
Re: Is it possible to "Save As" a Text box from one dashboard to another?
Perfect! God only knows how you figured that one out
Andy_A