Best Of
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
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!






