MarkSnodgrass Coach

You can go to developer.domo.com and create a developer instance for free and then invite your users to that instance as your sandbox instance. You can then use your main instance as your prod instance and set permissions as needed.

I have recently seen Domo e-mails being help up in our Exchange Server's Quarantine which require your IT admin do release them before they would even have the chance to show up in a user's Outlook. If your organization is using Office 365, this would be in the Office 365 Admin Center.

On the Single Value Card, in the Chart Properties → General, change Divide Value By to None. This will make it so that it doesn't abbreviate.

If you are referring to formatting the number in the summary number, you need to click on Formatting Options and then uncheck abbreviate and place a check next to use thousands separator. If you are referring to a number on a specific card, please tell us what card you are using and we can tell you which chart property to…

As @GrantSmith said, this feature doesn't currently exist. However, you can do what you want to do by breaking up your ETL into smaller ETLs for testing. Then, once you have it all sorted it out, you can copy and paste the tiles back into your main one so that you have a single ETL for production. I would create a ETL…

In the data center, you can click on the key icon on the left to view the integration accounts. Look for your SharePoint account. If you are the owner of it, you can click on Edit Account and see the Client ID and Secret. You would then need to go to your Azure Portal and verify that the client ID and secret still are…

Correct, you would create 5 rank & window tiles and then append them. I would also add a constant for each of them with the number of days that it is (7,30,90,180,365) so that you can use your variable slider on your card to then filter to the proper group of data. Missing days are important to take into account in both…

You could do this in ETL with the Rank and Window function, but you would need to create a lot of rank and window tiles and then append them all together.

You can do this by adding a variable control and then building a beast mode that is going to be a bit lengthy. In my example, I created a slider control called lag count that is a number that slides from 1-30. Next, I created a beast mode that will have a lot of case statements to build out the necessary number of days…

you can use the LIKE operator with the % sign on each side to make it look for the phrase contains. Would be something like this: CASE WHEN fieldname LIKE '%self-service%' THEN 'Self-Service' ELSE 'Something else' END

I tried entering values into both of those boxes and didn't find that it did anything either. I would suggest e-mailing Domo Support as it seems like a bug.

If you want to power a card from data stored in a Google Sheet, you can use the Google Sheets Connector. There is also the Google Sheets Writeback Tile if you want your Google Sheet to be populated from a Domo Dataset, you can use the Google Sheets Writeback Tile.

I was going to post about the iframe option, but I test it out and it renders the entire page inside the iframe which includes the Domo navigation menu across the top and sides, which I don't think is what he is looking for. You may want to look into this video by @jaeW_at_Onyx where he builds a navigation menu that…

The Domo For Office add-in that is now available in the Microsoft AppSource should provide you a better experience. It allows for writing data back to Domo as well as writing data to Excel. Setup should be a one-time process to get yourself authenticated to your Domo instance.

In the Pivot Tile, you will want to put Warehouse Clean in field 1 (Select the column that has the column labels you want). In Field 2, select your StockCode column. In Field 3, type Buford OnHand In Field 4, type Buford In Field 5, select the OnHand column. To add the Bufor OnSO, click Add Column and fill out fields 3,4,…

It's going to compare line by line. How did you join the two tables together? If you are essentially want to "search" the nxx column to see if there is a match with your substring value, you would need to a cartesian join that would repeat all the nxx rows for each phone number and then you would filter where there is a…

Your substring is looking at digits 4,5, and 6 in a phone number, not the first 3. Wouldn't you want it to be CASE WHEN LEFT(phone,3) = threedigitfield THEN 'Same' ELSE 'Different' END

It doesn't look like there is a built-in connector for this, but if Nextiva has an option to e-mail reports, you can use the Dataset via e-mail connector to automate the import process. The CSV Advanced connector is also good option as it handles https and sftp requests.

You could do something like this: CASE WHEN TRIM(fieldname) = '' THEN 0 ELSE IFNULL(fieldname,0) END This will check to see if it is blank or if it is null (which are two different things) and replace it with 0 if either are true. Otherwise, it will return the existing value.

It's very unclear as to how you can map the old user id to the new user id based on the way you are describing it. I would suggest you upload a spreadsheet that has two columns, old user id and new user id that serves as a lookup table. You can then create an ETL that has 3 input datasets: old id table, new id table, and…

Would be great to see this implemented.

You can use the formula tile and the split_part function to get the string after the hyphen. Your formula would look like this: TRIM(SPLIT_PART(fieldname,'-',2)) This will get the value after the dash and remove any extra spaces.

You could potentially implement a recursive dataflow that would allow you to look for new records and then assign them new ids while keeping the ids that have already been created. I think an easier and more sustainable solution is to use your concactenation of the agency and advertiser names as your unique identifier…

Here is the JSON for the ETL that you would like to put together. You will have to connect the input dataset to your actual dataset and correct any column name differences, but I tried to match your screenshot.…

Here is the JSON for the ETL that you would like to put together. You will have to connect the input dataset to your actual dataset and correct any column name differences, but I tried to match your screenshot.…

You should be able to do this in a beast mode, but leverage the fixed functions feature in order to have one number use the filter that is applied and one number ignore the filter. You can read more about fixed functions here: https://domo-support.domo.com/s/article/4408174643607?language=en_US

You can do this in Magic ETL, use the Rank & Window tile and use the Lag function to get the previous entry, which will create it as a new column. Next, add a Formula tile and subtract the two times. I would suggest using the unix_timestamp function on both datetimes and then subtracting. This will give you the number of…

I would suggest you Magic ETL to clean this up. You can have two filter tiles (one that has the data you need to clean, and the other data that is does not need clean). You can then do your cleaning using a formula tile and then append the two back together and output to a single dataset. You would then build your cards…

Killing the Workbench service in Task Manger or in Services should stop it from running.

Unfortunately, there isn't a way to have items in the legend change dynamically. I would suggest using the Hover Text Settings to provide the necessary information when hovering over an item on the chart. You can also submit the dynamic moving of the legend item as an enhancement in the Ideas Exchange section of the…