MarkSnodgrass Coach

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…

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.