jstan Contributor

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:…

Hi, does the SSO for Domo and Salesforce need to be on the same platform? We use Active Directory with Azure for Domo, but Salesforce will use a different SSO provider. Is it possible to still have unified login if we are using two different SSOs? They will both be SAML compliant. Thanks, Josh

Hi Scott, can you use a sumif/sumifs or vlookup in excel to narrow down the variances to specific rows? Are there any field values that contain what could be considered an operating character like a \ or " in the value (particularly at the end of a string). I have run into issues with those as well with the excel plugin.

Hi MErrichetti, you can also pull a lot of the same data from the St. Louis Fed (which is what we did because there is a lot more data out there). https://research.stlouisfed.org/docs/api/fred/ You can register for a free API key and we use the JSON connector to pull it. It should have all the BLS data there as well as…

Thanks Canio, embedded cards are also coming, so if you have SSO in Domo and Salesforce, you can embed a card anywhere in Salesforce. Here is info from Domo... Sharing Domo insights and content with your customers and partners outside of Domo is just a few clicks away with the Domo Everywhere: Embed feature. You can embed…

Hi Scott, do you have the same number of rows/columns in your excel download? Has the underlying dataset in Domo changed since you downloaded each dataset? Is the pivot table picking up all the rows? I ran into some issues where my dataset in Domo shrunk, but the excel plugin does not delete the old rows (had 100 rows, now…

Hi, I have had similar issues with certain characters in string fields not uploading through Workbench with the native local file approach. This included a comma quote deliminted CSV files that had something "" in the field value and a \ at the end of a string. We ended up subscribing to cdata.com ODBC drivers and use that…

Hi Vince, did you have any luck with the concur connector? I contacted concur and they said I would have to sign up for web services as well. It was not cheap. I was wondering if it is worth it, or I can just set up automated email extracts. Thanks, Josh