jstan Contributor

@GrantSmith I am still using Azure AD for authentication. @amehdad I am using the standalone buzz app that is an exe file (I believe v. 2.09) that can be found under the Tool Downloads section in admin. The more I think about it, I can probably create a reg edit script that runs after the install to at least get the domain…

The thing I have done in the interim is put an alert on datasets that haven't updated in XX minutes and control the minutes on a google sheet by dataset ID. I usually target my production datasets and then can dig into root causes. It updates every 15 minutes. Then I can get a single alert for all datasets I want to track.

The only difference that I know of is in the online data center, if you filter dataset results by Type, you would have both Workbench Excel and Excel listed. If you only wanted one dataset type, you could either (1) use the Domo API to switch the dataset types of existing datasets to Workbench Excel or (2) create new…

Hi, we have run into that issue as well with the email connector. You might have a few different options. There are Domo forms, which you can use to write to a dataset inside of Domo in real-time. You can contact your CSM about using it. I am not sure it is advanced enough to handle approvals if you do that now and…

Hi, the social users can only use buzz in Domo - so no card views/dashboard views (i.e. shared page). But they can receive scheduled reports that will show cards in an email (make sure to share the scheduled report card/page with the social user and add them to any PDP) - social users cannot click on the scheduled report…

Hi Olivia, I have not found a way - only a header above the total number. I would submit it as an enhancement request through the feedback button under more in your Domo instance. Thanks, Josh

We started running into a TLS error a month or two ago where workbench jobs we ran with windows scheduler were occasionally failing AND were not throwing an error in workbench. This was due to a Microsoft .Net issue using a non-supported TLS version (Domo ended support of older version of TLS earlier this year or last). So…

Hi, to reauthorize workbench, go to the accounts section of workbench (key on left) and choose reauthorize under the account you are using. Are you using the scheduler in workbench to run your jobs?

Nope, it just took me a really long time to do it on my own, I thought I would post it to help out anyone else trying to do it. Thanks

Hi @boujee_boolean with Stories you can now send wider data tables. You can move/copy a card to a new Stories page if you are not ready to convert the existing page to Stories. There is also another option that is not as intuitive, but you can use Campaigns. Campaigns allows you to fully customize reports to users and…

Hi, I use redshift datasets, so my code might a little adaptaption. You will need to use the BETWEEN in the join. SELECT * ,"Fiscal Week" FROM "FY18 MQLs" LEFT JOIN "Fiscal Week Ranges" ON "Created Date" BETWEEN "Start Date" AND "End Date" Second option is a case statement that adds a week to Friday & Saturday. Below is a…

This thread has not had an update in the past year, but I would really like to have fiscal_month, fiscal_year and fiscal_quarter commands available in beast modes. The reason that I cannot do this through a join is that I have a large dataset that times out with a fusion (I have added fiscal month, quarter and year to the…

Hi Jarvis, page filters are a big pet peeve of mine (3 out of 10 stars). Page owners should be able to do the following: * simple drop down at the top of the page where they can configure one or more datasets that the field applies to * ability to lock page filters to the page (kind of how the company page settings work…

* Create a bat file to call the jobs. * They will run in the order that you list them, so you can put multiple jobs in one batch file. For those not familiar with batch files, it is basically a .txt file with .bat as the file type. I recommend using Notepad++ to create them, but you can also use Windows Notepad. * Command…

Hi @guitarhero23, it looks like there is a bug in Domo. I found a way around it where it will abbreviate the value if that is ok. You need to create a beast mode that counts the records... COUNT(field). Use that in both the label name and value name. You could also use a COUNT(DISTINCT field) if needed. That will give you…

Hi @jonathanlooker, the reason you can get a divide by zero error is becuase you have division in your beast mode. A denominator can never equal 0, else Domo throws an error. My suggestion is you take the entire denominator and apply a case statement up front if the denominator = 0 then the value will be 0. You numerators…

Do you have any keys on the dataset and do you use workbench for updates? If so, you can do a full replace and then use an upsert dataset by flagging the keys in the dataset. This way, you will always have the latest version of the data. Go to the schema in the workbench job after the full replace. Then right click on the…

Are you creating this dataflow from scratch? If so, try emptying your browser cache and create it again from scratch. I noticed a lot of failures last night with datasets not loading into dataflows and I just recreated them until it worked. You can also try redshift vs. mysql to see if it works there. If it is an existing…

I haven't found a better way and sometimes the concats we use get really long. I wish Domo had a drag and drop summary number where we could add several numbers together and format it how we would like with a little more ease.

Just be careful on the LOGGEDIN command if you use Single Sign On. The activity log does not always capture mobile usage with the LOGGEDIN command at least with us using SSO. We sometimes look at the VIEWED command in combination with LOGGEDIN (or the SSO equivilent) to capture all daily usage. Either way, you should at…