-
How to extract a substring from an URL
I'm trying to extract the substring from an URL. Input: www.abcd.com/level1/level2 The output I'm looking for is essentially taking from the first character to the position of the second '/' minus 1. I wonder how to write the formula in beast mode. Desired output: www.abcd.com/level
-
MS SQL Server Connector Error
We have a job that extracts data from SQL through the SQL Server connector. It has been running successfully for a long time but it started failing yesterday. I tried recreating the data connection and let the query only pull data for a few days. It ran successfully. However, after I update the query to pull more data…
-
Pydomo: Error with 'ds_get'
I am trying to read a domo dataset in Python through pydomo. I got an error about encoding. My data contains name/address which may have special characters. I manually downloaded the data to csv and read it in with read_csv and had the same issue initially. However, if I include 'encoding='latin1' in 'read_csv' parameter…
-
Salesforce Marketing Cloud Rest Connector/ExactTarget Connector
We are trying to extract email data at the subscriber level with sends, opens, clicks and timestamps by campaign from Salesforce Marketing Cloud (SFMC). We used to be able to extract the data through ExactTarget Connector but the connector no longer works even with Admin right. We were able to connect through the…
-
Domo Map - Show State Only Instead of Whole US
Hello, I am trying to build a heat map at zipcode level. I wonder if it is possible to build it in a way that if I select 'Florida' as a state, only Florida is shown in the map instead of the entire US? Thanks!
-
Hyperlink
Hi, I created a Mega table and one of the columns is an URL. I would like the user to be able to click on the URL then automatically open a new tab and land on the page. I can do this in Tableau and I wonder if I could do this with Domo? Thanks!
-
How to erase all contents in a dataset without deleting the dataset
Hi, I have a data connector through the "DataSet via Email Connector" that reads the attachment from an email. I need to empty the dataset without having to change the email address. Does anyone know how to do it? I can delete this dataset and recreate one but I would prefer to keep the email address to avoid additional…