GrantSmith Coach

You can use a formula tile in a magic ETL to extract the first X letters and then the following numbers with the REGEXP_REPLACE function: Model Category REGEXP_REPLACE(`field`, '^(\D+).*$', '$1') Capacity: REGEXP_REPLACE(`field`, '^\D+(\d+).*$', '$1')

I'd recommend reaching out to Support to help get an answer as their technical team would be able to shed some light on to which service is needed for installation

Does Workday have a scheduled maintenance time when you have your job scheduled to run? Have you tried scheduling your job for a different time?

If we use today as an example: LAST_DAY(CURRENT_DATE()) returns 2023-10-31 LAST_DAY('2023-10-10') returns 2023-10-31 Comparing the two dates then shows that it's for the same month. It's shorter than having to compare YEAR = YEAR and MONTH = MONTH. This wouldn't work for previous years because it's looking at CURRENT_DATE…

My next step would be to create a new data table card group on the location and select the MAX of your date field to see what dates are coming across for your data. Also you can apply or ORDER_TYPE filter to it as well or include it in your table. This will help highlight if there's any missing days or when the latest…

You can try and implement indexes in your MySQL dataflow however I'd HIGHLY recommend rewriting your MySQL dataflow in Magic ETL as MySQL is sequential (it has to wait for each dataset load or step to complete before it can move to the next one) compared to Magic's sequential processing (can do many steps simultaneously).…

Are there other date fields in your dataset you're attempting to utilize? Regarding your beast mode the DAY(`Date`) >= 1 clause is redundant and will always be true. A simplified version of your beast mode would be something like: CASE WHEN LAST_DAY(`ORDER_DATE`) = LAST_DAY(CURRENT_DATE()) THEN 'YES' ELSE 'NO' END LAST_DAY…

With the LAG offset = 1 it will return the prior value. You then filter where the lag value and the current value has changed. This will show you when a record has changed. Once it's filtered you now have a list of all the orders that were either created or updated and the dates associated with those orders. You users can…

Currently the textbox card doesn't support a border color. The closest you could come is changing the background on the card on a dashboard but that's the entire card. If you're wanting just a border I'd recommend adding this to the Idea Exchange.

You can customize your starting day of the week you can look into setting up a customized fiscal calendar. This will allow you to define the start of the week.

It depends on the amount of data you're using in your joins and unions. There's a 60 second timeout that will cause it to not load a card when it's attempting to query a dataset so if you have too many columns or joins in your view it may cause a timeout and cause the card to fail to load.

The lag would show you when a value changed then when they're filtering between the two dates it'll show all the values that changed not just the prior date.

I'd recommend passing your dataset through a Magic ETL and utilize a Rand & Window tile with the LAG function. You can get the prior record for each order_number ordered by the snapshot date. Then filter your new lag ship date field where it doesn't match the original ship date. This will return records which didn't get…

There isn't a simple way to get the total percentage of null values within your entire data warehouse. You could utilize a scripting language to query a list of your datasets then using each dataset ID you could query each dataset with the query endpoint and have it count the number of values in each. This would take time…

I did dress up once as Frankenstien and had cardboard boxes cut out to do a fake head and blocky shoulders but that was a long time ago and no pictures exist (thank goodness!)

Another alternative is to utilize your own Date Dimension dataset to allow for custom offsets and allow for greater flexibility with the period types. I've done a write up on this here:

That's correct. Any time a card is loaded, filtered or modified it's issuing a new query into the database and since you're using a federated connection that's a new query to your database each time. More cards means more queries to your federated database.

Due to design decisions by Google the exported data won't align with the exact numbers from the UI. It will show you the same directionality of you data however. Here's some helpful articles on GA4 and sampling:

I'd recommend reaching out to Domo Support and logging a ticket if their documentation isn't lining up with the actual steps you need to take to get it configured. PlayVox's API documentation appears to be a bit light on the specifics of API authorization.

New values would need to be manually collapsed. I'd recommend adding an idea to the idea exchange to allow a setting so that all groups start collapsed as doing this manually for many different rows can be tedious.

You'll want to utilize PDP so that each user can only see their respective data. Here's a helpful KB articles to get you started:

It sounds like you want to pivot your data. You can utilize a magic ETL and a pivot column tile to change the structure of your dataset. You can refer to https://domo-support.domo.com/s/article/360044951294?language=en_US

If your decimal is the number of seconds you can use the SEC_TO_TIME function or convert your minutes to seconds and then use the function I’ve posted about formatting time differences which may be of benefit to you

Thanks everyone!

Due to how variables work the variable won’t remember the value you selected for a prior value of the variable column. I’d recommend adding this as an idea in the idea exchange

Typically when I'm looking to do something a bit different between with PoP charts I'll create my own date dimension with custom offset information. I've done a write up on this here: This method will allow you to filter for only Q4 and show the differences between the prior quarter.

Are all of your dates in ISO format? Did you previously write to the dataframe with the dates still formatted as a string? Have you tried writing to a brand new dataset?

@muhammadtalha - This was likely done using either a custom app or extending an HTML Domo Brick that Domo provides. Here's a link to the "HTML Links Dropdown Brick" that Domo provides (replace [YOURDOMAIN] with your domain or search for HTML Links Dropdown Brick in the app store…

data_import_from_file only supports CSV files. If your data in a structure other than a non-tabular format? How does the format break?

Domo also has a handy graphic on helping to choose different chart types depending on your data. You can reference it here: