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…

Hi Sarah, you will likely have to run it through a dataflow or use a calculated field (beast mode). Dataflow/ETL: An easy way to do it would be to get all the abbreviations from salesforce by creating a data table card from the existing salesforce dataset with the list of all the abbreviations and add an aggregated field…

Hi @TimmyB unfortunately with traditional dashboards, you are limited to 4 columns in a data table for scheduled reports. To get the four rows, set you font size to the smallest available and turn on text wrapping. When you see a card in a dashboard, the large size will show the same columns when it emails. You can also…

We have had similar issues with the emailer, Google Sheets and Excel files. Some things that we have done. * If you can modify the report to add a row below the header row, add another row that simply has alpha characters for text fields and a number for number fields. So we put Text in fields we want treated as strings…

Hi @user07951, every company can customize Salesforce with various configurations and custom fields. Our instance has several custom fields, even though sometimes there are already regular fields that are similar. What I would recommend is pull the entire task table (Select browse objects & fields, select salesforce object…

Hi, you can also use the Domo admin plugin for excel which will give you datasets, groups, users, PDP policies, cards, etc. You can download it here and choose export Domo Admin Data. http://app.domo.com/workbench/DomoOffice/admin/DomoAdminSetup.msi Thanks, Josh

Valid point as I have run into many issues with Null values in the past.

Hi @debbie_a, this is probably not the best example because you have four different denominators, but if you had only one denominator, you could put the (case when denominator = 0 then 0 end) up front, then run through them all. Here is what your beast mode would have to look like to use case statements. case when…

Hi @debbie_a, you can also use case statements for denominators. While adding 0.000000001 to a denominator works, another way that I teach people in my compnay is to use a case statement anytime there is a denominator. You can use case statements within case statements. CASE WHEN Denominator = 0 THEN 0 ELSE Numerator /…

Hi @rkehoskie I know this was posted a few years ago, but I thought I would add how we get SAP data in. We are using a CDATA ODBC driver to connect to SAP (ECC tables) and might soon use SAP HANA. For large tables to pull in history, we sometimes use BODS to extract the files to CSV or a SQL Server and then upload them to…

Hi @user08521, you can actually export the activity log using the Domo API. You can find additional information here: https://developer.domo.com/docs/activity-log-api-reference/activity-log. The dataset is called audit. If you do not have experience using the Domo API, you can find tutorials here:…