AS Coach

Regarding training, we've made certain DomoBasics training pages (see appstore) available to all users. For example, most of our users, naturally, are just data consumers, so we've added the Default user group, which contains everyone, to that Data Consumer Training app page. Contrast that with our Super User group, which…

I haven't been able to use DomoStats for this purpose, but it's also often been requested that we have the functionality to see upstream and downstream lineage of dataflows. We can only currently view upstream lineage, unfortunately. You used to be able to search the name of a dataset in the dataflow portion of data center…

Sorry, you're not referring to extracting data from Domo to use in another application? https://developer.domo.com/docs/dataset/overview-5 https://developer.domo.com/docs/dataset/import-and-export-data#Export%20Data https://developer.domo.com/docs/dataset-api-reference/dataset

Domo has an entire library of API calls you can make. Check out https://developer.domo.com/manage-domo

Why do you want different imports for different grouptypes? If you want to display charts with different grouptype values, you can bring in all the data and just filter the charts on your different grouptypes. We do that ALL the time. It's much better to bring in large batches of data and filter on the card (or data…

As far as the beast mode goes, if you're just trying to get the last twelve months, try something like this: CASE WHEN `SoldDate` >= DATESUB(DATE_FORMAT(CURDATE(),'%M %Y'), interval 12 month) THEN 'Yes' ELSE 'No' END That would give you a "Yes" for every row that is from the last twelve months. Use that in a filter. For…

We've used a skunkworks Domo Admin plugin that hits various Domo API endpoints and provides lists of lots of things: users, PDP policies, pages and cards, datasets, groups, etc. The pages and cards list gives you a list of all your cards and the pages they're on, along with owners and parent pages, etc. This might inform…

Are you looking for something different than the Cards and Pages menu options on the admin page?

I think you'd want to consider using the Bubble chart in the Data Science chart category. You can have three measures in that chart, each with different formatting.

Series values in Domo generally won't change colors like that based on certain values. Others have posted the request that those arrows change colors or direction based on being above or below a threshold, which makes great sense and would very much help call out the variation. Some other options: You could try a table…

That's really odd. If you use that output dataset in a card and do a distinct aggregation in a beast mode, do you get the same result as without the distinct?

Interesting. The only thing that comes to mind as @Valiant suggests is that there's a value, like a timestamp, that's a little bit different on each side. Maybe try doing the distinct or union logic on the datasets but removing suspicious columns beforehand, in order to determine if one column (or more) has distinction…

Are you seeing this behavior in the full output, or just in the transform preview? I've noticed transform preview problems before that end up being find when I run it, but if it's part of a fully run dataflow, then it sounds like a bug that should be reported. Your workaround with a DISTINCT sounds appropriate here. You…

We also had an unfortunate amount of difficulty connecting to SharePoint. We finally had to get in touch with our customer success manager at Domo, who connected us with Zack Cameron, Technical Solutions Manager at Domo. He helped us get the file path right and some other configurations in order to get it working. We also…

I don't know how others are doing it, but we have Okta for our single sign on solution, and we (the company or division admins) create user accounts, whereupon they usually receive the familiar "You've been Domo'd" email. They won't set up their password but will instead be redirected to the SSO authentication screen and…

Can you be more specific about the problem you're having and examples? We don't have much context here to go off of

Yes! You'll want to use the "Collapse Columns" action in the ETL tool. It works great for this purpose.

Are you maybe having firewall problems, and need to whitelist something on the network? I haven't seen this issue before, so I really can't say for certain.

Definitely: CAST(value AS type) For you that would be like SELECT ... CAST(`Min Cust Svc Start` as Date) ... Depending on what your string data looks like you might have to do some formatting, but the CAST could be the one you want. Also str_to_date works great. Format as necessary. STR_TO_DATE(tc.`Min Cust Svc Start,…

Totally. It needs a "Select All" option when using the search. @DaniBoy, what PM runs the quickfilter product feature? Is this feedback you can tag them in?

Have you looked into the PDP data security functionality yet? We used to use multiple filtered pages to solve this, but PDP really helped us streamline things. Users can have access on the data level to whatever you want them to have and nothing else.

@lucywo I think you'd be right on 1, but the OP said mySQL, not beast mode. I added the same type consistency comment in my initial response also, with the option of using NULL instead, though my inquiry about wich was preferred was not answered.

Unfortunately Domo doesn't really yet allow a fuzzy match in a filter. It's has to be a perfect match to the entire string. What you could do is use that comma separated list, and using a quick filter on the card's group field, search for your criteria, like the group number, and mark each checkbox that has an entry for…

I read your message to mean the field would contain a string of comma separated values like 'A,B,D'. In that case, the LIKE style statement would be correct. If the column is only ever a single character, @KurtF's response is the better, simpler way.

What I've seen done in cases like this set up a series of columns for each transaction row that assign that transaction to attributes like 'Is Salesgroup 1' or 'Is Salesgroup 2'. Then on the card you can filter to transactions that pertain to the business question. That said, 127 groups and 6 revenue categories is a lot of…

Nested beast modes would take care of this pretty quick, so you could reuse code and keep busy beast modes simpler. Until then, to crazy town we go.

Either the Booking IDs are all the same, or Domo is treating them that way. It sounds like they're all the same.

You can't declare variables or nest Beast Bodes in Beast Mode, but something like a case statement using LIKE would work. It would just get 'wordy'? CASE WHEN Alpha LIKE '%A%' OR Alpha LIKE '%B%' or Alpha LIKE '%D%' THEN 'v-Inefficient' ELSE 'Efficient' END

What does your entire transform look like? If this is a single column in your transform, then it looks fine to me. In total, it should look something like SELECT ... , CASE WHEN [your case statement] ... FROM ... Based on the error, it seems the problem starts where your case statement begins, which is either preceded by a…

I hadn't seen it but your column alias "new product name" has to be one string, not three separate words. END AS 'new product name' or END AS new_product_name or something like it Try that.