GrantSmith Coach

Hi @louiswatson You can do a left join from your existing dataset to your dataset 3 based on the Database Number. If the right table's Database Number is NULL then it doesn't exist in the left table. You can do a left join (or right join) and then filter on a NULL value.

You can utilize a Trellis Chart options in the bar chart. - This give more information on how to configure it.

You can use a formula tile and the regexp_replace function: REGEXP_REPLACE(`field`, '[\n\r]', '') [\n\r] - This is a selection of either types of newline characters (\n for mac/unix and \r\n for windows)

Are you able to do any other API calls with that client id and secret? A rate limit would return a 429 error code - Too Many Requests. This is pointing to a permissions issue.

Does your token / client id & scecret still exist or have they been revoked? Does the user that the token / client id & secret was created for have access to this specific dataset?

What does your function look like? You should be able to do something like this: STR_TO_DATE(`str_field`, '%b-%y')

Congratulations @colemenwilson!

You can use the STR_TO_DATE function in a beast mode or a formula tile in a magic ETL to convert a string to a date based on the format string. Documentation:

Case statements are evaluated from the top down and will stop when they find a condition that's true. Because you have WHEN STR_CONTAINS(AdditionalRecruiter,',') THEN AllRecruiter At the top of your case statement the other two below it won't ever get evaluated. Put the N/A and N/B conditions above this to have them…

If you're having an issue with the connector not returning the right amount of information from a Domo connector I'd recommend you log a ticket with Support to have them take a look into the backend.

Smart text doesn't apply to the bread crumb trail, just the current page title that's being displayed. I'd recommend logging an idea with the idea exchange to allow for smart text to apply to the breadcrumbs.

You've got a few too many closing parenthesis and aggregate functions. Are you wanting the filter none to apply to the engagements AND the page views or just the page views? Try something like this: SUM(`Website Engagements`) / SUM(SUM(`Page Views`) FIXED (FILTER NONE)) This will get the fraction of engagements of the…

I don't believe this is currently possible. One thing to keep in mind is that Excel has a limit of 255 sheets in a workbook which can be easily reached on some dashboards. I'd recommend adding this as an idea to the idea exchange. (

One workaround might be to utilize Window's task schedule to "manually" run the job at a specific time if the WB scheduler keeps disabling the schedule. You'd need to call the wb.exe (located wherever you have Workbench installed) yourself with the proper parameters (you can do wb.exe --help) to get the command line…

Hi @Jessica What does your HTML code like? Are you including your graph in a <div> tag? Have you set the margin on your <div> tags in the CSS to be 0? Also you could add a colored border to your div or other tags to see where they're actually being displayed to help diagnose your issue if it's within your HTML code or if…

Can you expand on what you're needing? Are you wanting to see the data after it's been processed by your function tile or are you wanting to know the underlying query for an API call? There isn't really a way to get the underlying query of the ETL as it doesn't exactly function that way. You can run a preview of your data…

Using a formula tile you can use a regexp_replace function to extract just the domain: REGEXP_REPLACE(`email`, '^[^@]+@([^\.]+)\..*$', '$1') ^ - match the beginning of the string [^@]+ - Match 1 or more (+) of characters that are NOT (^) the @ symbol. @ - match the literal @ symbol [^\.]+ () - Store this for later…

You can wrap your beast mode in an IFERROR function to default it to another value if there was an error with your date conversion

It sounds like an issue with your username and password. Have you confirmed they are correct? Are you able to use the same connection information with the MSSQL application outside of domo to connect to the database? Have you confirmed the server name is correct? Do you have an IT department to work with to confirm the…

What topics would you like to see covered at Domopalooza next year? In Person! Unique / Out of the box design solutions Data Governance Less Fluff, more substance. Not the What but the How. What features would you like to learn more about? Custom applications App Studio What are your top challenges in Domo right now?…

Hi @pwhite8 , You might want to look into domo.onFiltersUpdate() to do something in your brick when the filters update.

Currently this isn't an option. I'd recommend posting this idea to the Idea Exchange where other user can vote on this idea and help direct Domo's product roadmap.

You should be able to pass in the updateMethod=APPEND as a url parameter to the api endpoint.

I believe Domo defaults to Open Sans looking through the CSS.

I'd recommend logging a support ticket to have the Domo team look into this issue in the back end to see if they can find a reason why the dashboard copying isn't working correctly for you in this instance.

Currently I don't believe there is an option and that's something Domo would need to change. I'd recommend logging an idea exchange idea to support unicode characters during CSV exports.

The Domo Knowledge Base contains several good articles about transforming data within Domo. I'd recommend reading over these articles to get a good understanding of the transformation possibilities:

That's fine, you'd just need two different beast modes, one for display and one for sorting. Have the display on your table and the sort in your sorting options on the card.

It does. If fieldname is a timestamp you can just do this to get the numerical equivalent HOUR(`fieldname`)

Domo is doing string sorting and not numerical sorting because you value is a string. You can create a beast mode to calculate the numerical hour value (if you don't already have it) and then use that in the sorting section instead of your actual display hour string you currently are using. This way it will display how you…