Best Of
Re: Beastmode | Exclude data based on dates
Clean up your SQL and avoid using nested CASE statements. you want your code to read cleanly.
case when `Date` > '2021-07-01' AND `company` like '%company1%' AND `ConversionTypeName` like '%product1%' then 'exclude' else 'include' end
FYI it is syntactically correct to nest your logic using parenthesis, but again... avoid nested CASE.
case
when
`Date` > '2021-07-01'
AND (`company` like '%company1%'
OR `ConversionTypeName` like '%product1%' then 'exclude' )
else 'include' end
Re: How to Connect to a MySQL database using Workbench?
Hi @user041053
Id recommend looking over the knowledge base article on workbench and how to configure a job to start
https://domohelp.domo.com/hc/en-us/articles/360056669354-Workbench-5-1
Re: Dojo Contest is LIVE!
The Dojo is an awesome place to share ideas among users and with Domo folks. I love that Domo welcomes our voices and feedback to improve and enhance this amazing product. It's fun to make a suggestion and see others chime in with their use cases -- and so exciting when ideas are developed into real product features!
Re: Data Governance and Organization Best Practices
I recommend using the Domo Governance Datasets Connector to keep track of all your existing content. The "Datasets" report is especially helpful since you can more easily see names and descriptions of all the datasets in your instance.
If you don't do so already, I encourage you to use a standard naming convention across all datasets so you can easily see different attributes of your datasets such as department. That way you can more confidently search for whether data exists to fit a particular need.
Re: Multi-Value chart percent change error?
Hi @gospel
Its calculating the percentage difference between your two values and not the percentage point difference like you’re expecting
(95.42-94.83)/94.83 = .00618 * 100 = 0.62%
Security Best Practices for Inviting External User to Domo Instance?
My organization wants to be able to collaborate with one of our customers to develop performance metrics that combine their data with our own. We are considering providing members of their technology team access to our Domo instance so that they can accomplish any of the following tasks:
- Create/edit datasets from their own systems (ODBC, file upload, API connector, etc.)
- View/edit dataflows that use the datasets they own
- View/edit cards and pages that use the inputs/outputs of the dataflows they have access to
It's also critical that we keep their access very limited because of the amount of proprietary data that we already have in Domo that they should not be able to see. This is my current plan for managing this initiative, but I am open to feedback or suggestions:
- Create a shared user for the external team using the default Editor role
- Add the user to a new group that includes any internal collaborators
- Run all relevant internal datasets through dataflows to remove sensitive information (financial information, customer names, etc.)
- Share the cleansed outputs of the dataflows with the group so everyone can access downstream dataflows
- Share any datasets created by the user with the group
- Create dedicated page(s) for the group to add/edit cards
I'm open to input from anyone who has had a similar situation or if I'm missing any crucial for security. We haven't had much use for custom roles or PDP, so I'm curious whether I should consider those options as well. Thanks!
Re: How do you see all cards associated with a Dataset as an Admin (when not shared)?
You can see all the cards related to the dataset if you have access to the pages on which the cards lie. I generally being an 'admin' add those pages under my profile and then i can see those cards under the cards section when i click on the dataset.
If they could change this to an admin can see every card related to the dataset even if he/she doesnt have access to the page, that would be great.
Hope this helps.




