Best Of
Domopalooza announces SHAQUILLE O'NEAL!
You can't spell Shaquille O'Neal without 'AI', and you can't host THE AI + Data Conference without Shaquille O'Neal! He's shattered backboards, won three NBA Finals MVPs en route to four championships, made a second career as a TV commercial legend, donated countless hours and $$ as a philanthropist, and won everyone's heart over as a television personality for the last 14 years. And now he's taking the stage at DP25. You can't get any bigger—in any way—than SHAQ.
Re: How to list Domo AI Models and its meta data
Not that I can find anywhere unfortunately. Domo isn't great at documentation, especially with newer features.
brycec
Re: What's Your Asian Zodiac?
So many goats like @ColemenWilson and @akeating. They are grazing on the Domo Community Forum
Re: Filtering on Null Values
@chris_schenk great idea, thanks for posting here. This is certainly a request we've heard before and is something we'd love to include in the product in the future.
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
