GrantSmith Coach

There's an existing request in the Idea Exchange I'd recommend upvoting: https://community-forums.domo.com/main/discussion/61163/in-dashboard-navigation-options

You can have Domo configure a fiscal calendar and you can then use the standard period over period charts: https://domo-support.domo.com/s/article/360042924254?language=en_US Alternatively I'd recommend utilizing a custom date dimension where you can a define your fiscal years and also custom offsets. I've written up an…

Regarding question 2 it will evaluate it in the orders of parenthesis first and then AND/OR equally going left to right so you're correct in that it will evaluate it like (A AND B) Or C ) AND D

You'd do the same thing above except use the batch id instead of the date to get the latest batch ID records.

You'll need to pre-aggregate your data with a window function in Magic ETL in order to keep all-time around. Window functions in Beast Modes will only apply on the data that is available after filtering.

I'm assuming by the latest row you mean the one with the most recent date and not the last row in your dataset. Using Magic ETL - feed your dataset into an add constant tile, add a constant called "Join Column" with a value of 1, feed that into a group by tile and group by this new field selecting the Maximum date, then…

It’s the user you’re impersonating a member of the Domo Workbench User group?

You can use the same regular expression for all parts of your string and just use a different matching group: Model category: REGEXP_REPLACE(`field`, '^(\D+)(\d+)(\D).*$', '$1') Capacity: REGEXP_REPLACE(`field`, '^(\D+)(\d+)(\D).*$', '$2') Multiplier: REGEXP_REPLACE(`field`, '^(\D+)(\d+)(\D).*$', '$3')

Alternatively, you can use the same regular expression for all parts of your string and just use a different matching group: Model category: REGEXP_REPLACE(`field`, '^(\D+)(\d+)(\D).*$', '$1') Capacity: REGEXP_REPLACE(`field`, '^(\D+)(\d+)(\D).*$', '$2') Multiplier: REGEXP_REPLACE(`field`, '^(\D+)(\d+)(\D).*$', '$3')

Hi @NathanDorsch REGEXP_REPLACE(`field`, '^\D+\d+(\D).*$', '$1') Should return you the character after your digits.

Something like this can work. You can tweak based on your logic but I tried to give several different examples: CASE WHEN date IN ('2022-01-01', '2022-02-01'…) THEN 'Exclude' WHEN YEAR(`date`) = 2022 THEN 'Exclude' WHEN DAYOFMONTH(`date`) = 1 THEN 'Exclude' WHEN DAYOFWEEK(`date`) = 4 THEN 'Exclude' WHEN LAST_DAY(`date`) =…

Your jobs are backed up by Domo for your specific machine that's running workbench. I'd recommend exiting out of workbench and launching it again to see your jobs or alternatively restarting your workbench server. If you do want to export your jobs out of Workbench you can use the wb.exe executable located where you…

You'd need to enable it on each card you wish to use with the fiscal calendar. https://domo-support.domo.com/s/article/360042924254?language=en_US describes how to do this for reference.

Alternatively instead of LOWER() you can just use ILIKE which is the case-insensitive version if LIKE. The % at the beginning will match 0, 1 or multiple characters so it will still match aetna at the beginning. If you had just aetna% then it'd only match the value at the start of the string. But your beast mode looks…

Is your Day field a date or is it a string? If it's a date you can use two beast modes to set a sort order Month sort LAST_DAY(`Day`) Put this in the sort and sort it descending Day sort: DAYOFMONTH(`Day`) Then put this in the sort after the month sort and sort it ascending.

A simplified Beast mode would be something like: `Start date` - INTERVAL DAYOFMONTH(`Start date`) DAY + 1 - INTERVAL MOD(MONTH(`Start date`)+2, 3) MONTH Detailed Breakdown: `Start date` - INTERVAL DAYOFMONTH(`Start date`) DAY + 1 Returns the first day of the month for a date with start date. DAYOFMONTH returns the day…

Have you tried to re-authenticate workbench or restarting your workbench server?

Under general properties on the Table chart, you can set Show Negative Numbers in Red checked to make negatives red. Also you can use the color rules to always set your value as green. the negative Red should override the color settings. See https://domo-support.domo.com/s/article/360043429573?language=en_US for reference

You should be able to still own the alert but unsubscribe for it by making sure all of the notification method iconds (mail, phone, sms, phone) are unchecked (black) and that should unsubscribe you from the alert without causing you to lose ownership of the alert. See…

Also, if you want to check if something is numeric you can use a regular expression here as well: CASE WHEN REGEXP_MATCH(`field`, '^\d+$') THEN 'Numeric' ELSE 'Non-Numeric' END

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. https://domo-support.domo.com/s/article/360042924254?language=en_US