NewsomSolutions Domo Employee

You can go to Advanced Scheduling and change it to every 15 minutes. That is about the closest I think you're going to come to automatic. But maybe I'm wrong.

I heard back from my CSM - the features were just put in Beta. They won't be out for another few weeks. Disappointed for sure. I was looking forward to testing that out.

@ST_-Superman-_ The data science actions if I understand correctly are going to be paid features, not built in. You'd have to reach out to your CSM to get them activated, but when I did last week they told me it was a paid thing and they'd be emailing out more material about it in a few weeks.

You can use hyperlinks in a Notebook card...you could also use the 'Doc Card' and have the youtube video embedded in PPT slide. https://www.youtube.com/watch?v=OEpbmaX2zJQ 

Google forms is great. Here is an overview from zapier, but you don't have to use zapier...just use Google Forms. https://zapier.com/learn/google-sheets/how-to-use-google-forms/ then if you want that data into Domo, use the Google Sheets connector to make that happen. if you need your forms to be nicer looking there are…

If you have that Batch Last Run as a date field in your card...set it up as a Beast Mode "Called BM - last run"...then use Max(batch_last_run) -- which will give you the lastest date...and then create a summary number in your card with that value.

Also if for some reason the mysql in domo doesn't like the last option, you could create a new column in that table employee roster table by doing something like this "select agent name, agent name two from employee roster...and then on your join you'd be technically joining two seperate columns...but the values would be…

Then try SELECT a.*,b.* FROM `Conversations` a LEFT JOIN `Employee Roster` b ON a.`Conversation Assignee` = b.`Agent Name` and a.`Conversation Rating Assignee.` = b.`Agent Name`

Is it also being used in a Beast Mode? Sometimes I have to change the card type to Table or something else and then go back for that 'flag' to be removed...so you may want to try that if all else fails.

I find this helpful too https://www.piliapp.com/mysql-syntax-check/

Maybe my SQL is weak, but why wouldn't SELECT a.*,b.* FROM `Conversations` a LEFT JOIN `Employee Roster` b ON a.`Conversation Assignee` = b.`Agent Name` LEFT JOIN `Employee Roster` b ON a.`Conversation Rating Assignee.` = b.`Agent Name` work for you?

Thanks Jarvis - Yes, that is what it is. I was really wondering if anyone had used it yet. The customer base so far is pretty small for it so I was trying to get some feedback from those that may have already purchased. Thanks again.

I'm not sure this helps any but if I were using that chart and couldn't show distinction between the values, I'd try to extend the scale of the chart first and see if that spreads them out (doubtful). Next I would see if I could display that data more effectively using another chart type. I don't know what data you're…

Thanks - I was calling in after I replied and got the same confirmation that you did. They are working on it and it hopefully will be resolved "soon"...today or tomorrow hopefully. There is also another known issue with data flow errors since last night's maintenance ...so FYI if anyone else has weirdness.

Yes, I'm getting this today....on an ETL that I am adding the filter in. But everything is legit. Did you find a resolution? - Matt

I reached out to support and wanted to tell you what the issue was. The page was set up as a Company Page...so you can't manage Company Pages in the "manage pages" section which seems weird, but anyone runs into this...that's the reason.

Also - I do see the page in the Admin - Pages section...just not the 'manage pages' so I guess I could add a new subpage as a parent page and then move it from there. Just seems odd.

I just introduced my palm to my head after I read that. I did leave off ALL. Crap. Thanks for chiming in and helping me out. Good catch! I should have used UNION ALL but left it out.

@ilikenno thanks for that. I didn't even think about stripping it out and doing it that way but that is an option. I think you're right though, it may be best to just keep in SQL for sake of simplicity of troubleshooting. Thank you.

You should put this in the ideas section. I'm sure you're way beyond needing this now but this is a good idea and I think that it would be helpful. If people could 'quick filter' on multiple cards at once it could be very helpful.

No, but I think this is really a problem on the box.com side, not with DOMO. But if your support team wants to work with box that is great. the problem is that when you search for a file in box, even with just one letter it finds nothing. So when I have files in domo with just a partial name, to leave off the date field,…

And it is working fine with existing connectors just the new ones it is not working with. So not sure if they (box) haven't indexed their newer files or what.

Yea, the PPT and the Mobile looks the same to me. I get the PPT by doing the Publications and then saving it down as a PPT. The cards look great with the added HTML in the browser, but with the PPT it doesn't work...but I guess in theory it really shouldn't since it's being taken offline, I just wish we had an option to…

You're the best. Thanks...I knew that but just had left it off. Thanks for knocking me into gear. Thank you again!

I'll add it. Thanks for replying.

Just my two cents, I'm adding this since you said you were a newbie...but...IF you can do a similar conditional ETL in Magic I'd do that because the performance of Magic ETL is better than MySQL, but it's functionality may not be as great. As your data grows you may feel it the performance difference.

Yes. I took Aaron's sugestion above and that worked for me. The Box connector in Domo does only select the most recent file so if you have the file name in the connector (the part that doesn't change) it should grab it without a problem. Something to keep in mind. As I have multiple files going from 3rd party sources to…

Aaron, thanks for the reply. I'll try that out and let you know how it goes. Thanks again!