Best Of
Re: How to remove all grid lines except for X & Y zero lines
@Data_Devon I'm here to chime in! Hide grid lines and then add quadrant lines = 0
Re: Variable connected to a Filter Card
Thanks Grant, I will add this to idea exchange. I did just figure out a work around for now. I had to create a filter view and click on the field that is connected to the variable and filter by count>= 0. This works for now!
MGDOJO
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: December Community Recap
Congratulations @Data_Devon! @everyone please upvote The Text Card idea!
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: How can I set up a graph to show period over period data in a dynamic way?
@hollyrene1225 - I recommend restructuring your data so that you have multiple periods within the same dataset. I've done several writeups on this and it allows you to show multiple periods on the same graph. You can find more information on how to do this here:
Re: Recent Editable Data Webinar question
I just pulled up the code that I think is what I used in the webinar?
In the app.js file, line 54 has the filter. If you comment out line 54 and line 57, and uncomment line 56, that should get rid of the filter.
Re: Recent Editable Data Webinar question
Yeah, totally. If I recall, in the example we set it up with a filter. It filters out the ones that have had the action taken on them. You could remove that filter from the query. There's also a section in the code that handles whether a row "isEditable". I believe in the example we set that to true, so they are all editable. You would just need to remove the filter from the query.
Re: Do Domo connectors work with MFA
Update here, even though I set up MFA on the Facebook account used to pull in data, the connector still works fine. Based on a support ticket I submitted the Facebook connector is an api and is not affected.
Re: How to re-subscribe a Domo emailed report recipient
@elvira_bannon Once a recipient unsubscribes from a scheduled report, they cannot be added back to that specific schedule. You will have to create a new instance of the report schedule by choosing the "Schedule as Report" option from the card/dashboard you want to sent and reconfigure the original schedule with that person as a recipient.
