MarkSnodgrass Coach

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…

you can use the like operator along with the % sign which acts as a wildcard when Business Division_p LIKE '%Biologics%' then 'Bio'

You can do this by using a window function in a beast mode. You may need to ask your CSM to enable window functions in beast modes. Once that is enabled you can create a beast mode like this: RANK() OVER (PARTITION BY YEAR(date) ORDER BY SUM(valuefield) DESC) You would then add this beast mode to your filters and filter to…

If you are in a table card, one way is to drag that same column in again as the 1st column and choose count. Then in the chart properties, General - Hide Columns, enter 1. This will hide the 1st column and the aggregation that you chose will remove the duplicates.

You can construct the format through some elaborate beast mode syntax, but it will still be viewed as text. If you search the community for beast mode formatting, you should see some examples. You could add a round function to eliminate pennies very easily, but the commas and $ signs require an elaborate beast mode.

Try switching to the HTML table chart type and see if that works.

If you are using a mega table, you can create beast modes that color the numbers like this: CASE WHEN budget > actual then concat('<div style="color: #ff0000">',`budget`,'</div>') else concat('<div style="color: #00ff00">',`budget`,'</div>') end This would turn the budget red if it is higher, otherwise it will be green.

No, there is no Mode function. You could potentially calculate it with a group by to count the number of values and then use rank & window to rank them by count and then filter to where rank equals 1.

@Newbie23 glad we could help. If you can mark any answers that helped you as accepted, that will help others in the community.

First I would make sure that the column is included in the select columns tile at the end of the ETL. Next, I would edit the card in Analyzer and click on the Date Range selector in the top right. Ensure that Hide Date on Card Details is not selected and that the appropriate Date Range Field is selected.

Since your field only contains the month and the year, I recommend using the split_part and concat function to pull out the month and year and set it to the 1st of the month. You can do it like this: DATE(CONCAT(split_part(Monthfield,'-',1),'/1/',split_part(Monthfield,'-',2))) Wrapping the DATE() function around all of it…

See if this works for you: CREATE PROCEDURE GetAllDates () BEGIN DECLARE l_cnt INTEGER DEFAULT 1; DECLARE l_region VARCHAR(10); DECLARE l_org VARCHAR(3); DECLARE l_ordered_item VARCHAR(100); DECLARE l_date DATE; DECLARE l_group_sequence INTEGER DEFAULT 0; DECLARE C_DATE CURSOR FOR SELECT DISTINCT REGION, ORG, ORDERED_ITEM,…

You can also make it a text in a beast mode by wrapping a CONCAT() statement around it and put that in the items list: CONCAT(yearfield)

You could use the Java CLI tool to do this, but it would likely be a manual approach. I know you want avoid creating an ETL, but creating a simple Magic ETL with a filter tile that looks at the current date and the date field in your dataset would be an easy and dynamic way to filter out the older data.