GrantSmith Coach

The issue is with the count portion, are you looking for distinct row counts you can CONCAT all of the fields together: COUNT(CONCAT(Plant, Group, Code, Month, Name, Part Number1, Part Number2))

CASE WHEN QUARTER(`booking_date`) = QUARTER(`shipment_date`) AND YEAR(`booking_date`) = YEAR(`shipment_date`) THEN `Shipment Dollars` END You'd want something like this then

To get the dollar amounts you can use Mark's logic to return the amount for the quarter: CASE WHEN QUARTER(`dt`) = QUARTER(CURRENT_DATE()) AND YEAR(`dt`) = YEAR(CURRENT_DATE()) THEN `Shipment Dollars` END

You can use the Alter Column tile to convert your string to a date type field. You'll need to specify the date format as %d.%m.%Y. Alternatively you can use a formula tile and the STR_TO_DATE function to convert it to a date: STR_TO_DATE(`date_field`, '%d.%m.%Y') Here's more information on date formatting characters for…

The Overview is an interesting special page. It is generated based on whomever is logged in so the ID will be the same however the cards that are associated with that specific page are dependent on who you are authenticated as. You'll likely just need to create several different tokens for the different users and repeat…

Are you looking for the actual definition of the dashboards or just a picture of the dashboards? Domo's Public APIs don't have a a way to currently do this but you could attempt to look at the lower level APIs which wouldn't be supported. Alternatively, have you tried using other automation packages to go to your dashboard…

The connectors currently don't support functionality like this doing a historical backfill. You'd need to do it manually.

At this point I think support will be your best option. Typically in the past when I’ve seen this issue was because the system wasn’t running the service scheduler properly but it sounds like you’ve already restarted and investigated that.

Simply put the publish dataset is being read from the main instance and not the publication instance. Same concept as a federated dataset but instead of a Domo database it’s pulling from a different database like snowflake

.

You'll need to log a support ticket then to have Domo's development team investigate the issue as it appears to be a python package issue.

Try and comment out your lines of code until you no longer get the error message. Is it in the summarize function call or does it happen when importing the package? im guess that you’re trying to use it in a non Domo Jupyter workspace which is likely causing the issue

Give your machine a reboot that typically solves problems I have with workbench.

If you have garbage data which doesn't match your date format ('Day' in your example) it may not be simple enough to just convert it to a date. You may need to conditionally set your date value: CASE WHEN REGEXP_LIKE(`date_field`, '^\d{4}-\d{2}-\d{2}$') THEN STR_TO_DATE(`date_field`, '%Y-%m-%d') END

Embedded dashboard currently don’t support scheduled reports. You can add this as an idea to the idea exchange to see if they may add it in future releases

Date BETWEEN DATE('2023-10-12') AND TODAY() in a filter file with a formula criteria

You need to edit your dashboard and change the card interaction to drill in place that would allow it to access the drill path Rather than filtering your dashboard

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.