Best Of
Re: workbench job - syntax auto fill
You cannot but I’d recommend adding a new idea to the idea exchange
As a workaround I’d recommend writing your query in an actual database IDE and then paste it into workbench
Re: Setting company timezone back to UTC or Undefined'?
@CR123 It appears to be listed as "Coordinated Universal Time" in the time zone drop-down under "Formatting"
Re: Upcoming January Feature Release-January 24th
I was definitely someone that saw the pop-up and then wanted to refer back to it, but couldn't find it. Thank you for posting it here.
What's the graph view for Magic ETL? Or is there more information about it somewhere?
Airtable API Key Deprecation
Domo's Airtable connector ( ) currently requires an API key to authenticate to Airtable. Airtable is deprecating support for API Keys on Feb 1st 2024, which means that Domo's connector will not be able to connect using API Keys after that date.
A new connector to Airtable using OAuth to authenticate is now available at https://your_domo_instance.domo.com/appstore/connectors/com.domo.connector.airtable.oauth?origin=search. This connector has the same reports as the Airtable connector that uses the API Key, but it supports OAuth authentication, which is recommended by Airtable.
Customers who have powered up datasets using the API Key version of the connector, and need to continue pulling their Airtable data after Feb 1st 2024 are strongly encouraged to try the OAuth version of the connector before Feb 1st. As the API Key version and the OAuth version of the API are two different connectors, customers who wish to migrate their datasets to the OAuth version should contact Domo Support.
Tasleema
Re: Unexpected error with pydomo "ds_update"
This appears to be a system-wide issue. I'd recommend logging a ticket with Domo Support. I'm having the same issue as well.
Re: Creating a Beast Mode to calculate field sums for remainder of year
I realized I didn't replace the other current_date references with date. it worked this time
thanks for the assistance!
markb
Re: Beast Mode for same date check
Hmm the way I would do this is still in MagicETL. I would convert the timestamp using a formula tile with the following formula:
CONCAT(DATE_FORMAT(`Date`,'%m/%d/%y %k:'),(CEILING(DATE_FORMAT(`date`,'%i') / 5) * 5))
Then follow the same process I mentioned earlier, but use this field instead of your date field. What this will do is group everything to the nearest 5 minutes. So if you have a company created at 12/01/2023 8:15AM and another at 12/01/2023 8:13AM they will be grouped together.
Re: Average Loan Size
You can use a beast mode to calculate the average
AVERAGE(`Loan Amount Field`)
Then you can use it as a summary number or put it into a tooltip field and reference the tooltip in either your data label stubs or hover text settings