Best Of

Re: I want to fetch count of data for a specific time frame (mon-fri)-(9-17)

@dheeraj_sandhanshi You can set up a beast mode like this to segment what data to filter:

case
  when DAYNAME(`DateField`) in ('Saturday','Sunday') then 'Exclude'
  when HOUR(`DateField`) >= 9 and HOUR(`DateField`) < 17 then 'Include'
  else 'Exclude' 
end

MichelleH

2

Problems with Workbench, ODBC, MySQL and the data specialist exam

Hi

I have a problem with taking this exam: https://learndomo.domo.com/learn/course/383/play/1608/data-specialist-practical-test-2h

The task wants you to use Workbench 5 to set up a MySQL job and then import the data from Workbench to Domo. The connection to Domo from Workbench works fine. When I use the parameters for the MySQL server, I get the following error:

[03.31.21 5:19:30 AM] Value cannot be null.

Parameter name: input

I have tried using the System DSN that has been configured and also the Connection Builder using the parameters mentioned. The problem is always the same. I know the ODBC connection works as I can pull a table into Access using the same Domo DSN Connector.

Just wondering if anyone who tried taking the exam ran into the same problems?

Thanks

Ian

IanMaddrell

1

Upcoming January Feature Release-January 24th

We are excited to have new features shipping to customers next week. One of my core goals for our team this year is to improve release transparency. Many of you noticed that we did send an in product announcement last week with a list of the upcoming new features. I have heard from some that they saw it but now want to go back and see the list. While we figure out if there is a more technical way to do this, I did want to share a PDF with the preview screens you would have seen in Domo. Excited to get these features out to all of our users soon!

Upcoming Product Release - January 2024-20240116.pdf

BenSchein

15

Re: Dynamic Columns Line Chart?

Variables are an easy way to swap out fields in a line chart. Here's the KB article with a video if you are unfamiliar with it.

https://domo-support.domo.com/s/article/7903767835031?language=en_US

MarkSnodgrass

1

Re: Determine user landing page by group membership

You have to use the Group ID and you can find it in either the Domo Governance Dataset "Groups" which can be found in the appstore by searching "Domo Governance Datasets Connector" or by going to the group in Domo and copying the ID from the URL: