Best Of
Re: Changing a value to an integer in the ETL
You can use the value mapper to map the 0 to an empty string (click the gear icon on the replacement field - select empty string) before you use the Set Column Type.
Re: Background Image for Stories
Hi @Ashleigh, according to DomoHelp, background images are recommended to have a size with a 2:1 ratio, so agreed with @MarkSnodgrass advice. But that's all the guidance provided online in terms of dimensions for background images :/
Re: Background Image for Stories
There is not a concrete answer for this because what a person sees in their background is reflective of their screen resolution as well as how many cards that you have on the dashboard that require vertical scrolling. I would suggest at least 1400x700, but you may need to upload a couple different sample images that are different dimensions and see what fits your dashboard best.
Re: Cool blog post on DDX Bricks
Keen! Any indications on around when this would be available?
Re: Aggregate Count of Line Items by Distinct Orders
if you're trying to group orders by number of items
ex. (orders with 5 or more items, orders with 2 items , orders with 1 etc), then you definitely can't take the approach you're taking. you need to create a column that counts the number of orders per item. you'll have to materialize it into your dataset (do it in ETL).
then you can do a beast mode to create your num_item_buckets using a CASE statement.
Re: How can I group multiple columns by year-month in the dataflow?
This'll sound snarky but isn't meant to be. Did you try it?
Yes. Lead and Lag still work.
Domo is a phenomenally powerful platform that is not completely documented because groundbreaking changes come out every quarter. I strongly recommend that you get used to both trial and error and googling your question.
A year and some ago, Domo opened up their site to Google's search engine, making Google the best way to search for information about Domo (as opposed to using the built-in search which is ... subpar IMHO.
Re: Campaigns App Data not rendering
Actually figured it out. It was right there in the FAQ's. Just need to check "Disable strict no data checking" in the settings tab of the campaign. This will allow the campaign to deliver even if one or more cards has all the data filtered out.
Re: Add multiple Hyperlinks in one cell
Hey @jaeW_at_Onyx
Thanks for the info.
I generated a Domo ticket and discovered it's not possible at the moment to separate hyperlinks from texts or have multiple, in cell.
I submitted a suggestion though, so hopefully in the future it'll be possible.
Re: Add multiple Hyperlinks in one cell
Make sure you are using the HTML table card. In your beast mode, you can use one CONCAT function and have as many links as you want. Example:
CONCAT('<a href=https://www.google.com>Google</a>',' ','<a href=https://www.yahoo.com>Yahoo</a>')