-
Count the number of upper case letters in a string
I am trying to determine if all letters in a field are capitalized. for example: String| Count ABC | 3 abc | 0 Abcd |1 How can I calculate the 'Count' in this example?
-
Ability to Filter Cards under a dataset
I would like to propose a change which will help us find the card easily under a dataset. Currently, there is no filtering option. When there are large number of cards created under a dataset, there is no way to filter the cards to find the ones we need. Finding the card can be time consuming and many times, we end up…
-
SFTP Writeback Connector with Public Key File
I am trying to create an SFTP writeback connector. The SFTP instruction indicates I need to create and upload a public key file to FileZilla. I created it. However, there is no place to upload a file in Domo. I wonder if there is a workaround? thanks!
-
Cumulative Sum with Windows Function
I'm trying to use windows function in the new SQL tile. For example, I have a dataset with three fields: Gender, rank, students; I want to aggregate by gender, sort by rank and sum students cumulatively so the last row of each gender category contains the total number of students. I tried the following query and got an…
-
Issues with Multiple Variables in a Dashboard
I build a dashboard with 30+ control variables using one dataset in the backend. Users seem to have issues updating the dashboard after entering values. It either crashes or not updating. Is this expected?
-
Moving Sub-Dashboards from One Dashboard to Another
Hi, I am trying to move a sub-dashboard I created under dashboard A to under dashboard B, is there a way to do it? The reason I have to created the sub-dashboard under A first is it is a copy of an existing sub-dashboard under A. I need to replicate it to be a sub-dashboard under B. I have tried to move it under 'Manage…
-
Hashing Data in Domo
I need to generate a file with PII data but we want to hash the data before downloading. Could anyone point me to the right direction on what can be done in Domo? the data is in Domo.
-
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…
