Best Of
Re: Domo Workbench 5: Unable to Query Provider Types
No but I've had some similiar issues and haven't found a great solution for them yet.
Re: Need Help: Subtract CurrentRowDateTime - PreviousRowDateTime from same column
You can do this in Magic ETL, use the Rank & Window tile and use the Lag function to get the previous entry, which will create it as a new column. Next, add a Formula tile and subtract the two times. I would suggest using the unix_timestamp function on both datetimes and then subtracting. This will give you the number of seconds difference between the two times. You can then multiply by 60 to get to minutes and multiply by 60 again to get the number of hours.
Hope this helps.
Re: Considering Domo Everywhere
- How exactly does Domo Everywhere work? Is it an add on that you purchase to basically iFrame a dashboard to an external website?
Simply yes, there are two different versions of Domo Everywhere / Domo Embed - There's a private embed which allows you to utilize an iFrame but requires users to have a Domo license. Then there's Public embed which allows anyone with the URL to access the embedded page or card. This can be wrapped in your own UI behind a login
- Cost? What does pricing look like?
You'd need to talk with your Account Executive to get pricing information but you're typically charged on per impression basis for each card. So if you're embedding a page with 10 cards on it every time the page is loaded, reloaded or filtered you're using 10 impressions.
- Let's say we get it, based on your experience, what does the user experience look like for non-domo license users when they interact with "Domo Everywhere content"?
It's a limited interaction but users can export data or filter data.
- Does Domo Everywhere allow for PDP filtering? If so, how does that work for users who are not Domo users?
To better future proof, Domo recommends using programatic filtering instead of PDP due to potential issues with cookies. See https://developer.domo.com/docs/embed/filtering-options for more information on filtering options.
I'd recommend reviewing the documentation at https://developer.domo.com/docs/embed/embed-2 and also going to https://[YOURINSTANCE].domo.com/domoeverywhere for more information.
Domo has an example page where they've embedded a dashboard with Covid-19 information here: https://www.domo.com/covid19/daily-pulse/ to give you an idea of what it can look like.
Re: HELP! Can not get this ETL Formula to Validate
@jtrollinger In addition to Grant's feedback, you only need one ELSE to designate 'Others'



