Best Of
AI Agent for dataset AI Readiness walkthough app
π New in the Domo Solutions App Library
Our latest addition is now live: an AI Agent for Dataset AI Readiness.
This workflow + AI agent makes it simple to automate AI readiness across your datasets, saving you from the manual work of reviewing each column, adding context, and defining synonyms.
π‘ Our walkthrough uses DomoStats datasets as an example, but the guide is designed to help you adapt the process to your own data needs. Itβs especially powerful if you manage a large number of datasets and want to accelerate AI adoption without sacrificing consistency.
π Explore the walkthrough AI Agent for AI Readiness app here: https://embed.domo.com/embed/pages/MZrQm
π See the full collection of Domo Solutions apps here: https://embed.domo.com/embed/pages/mO1RR
JedP
Re: domo.onDataUpdate() Bug
Thank you! Sadly still haven't been able to get anything from Domo despite being a Diamond support customer and submitting the issue over three weeks ago so this is greatly appreciated!
collinT
Re: Salesforce Advance Connector - Browse Object Tile vs Browse in Bulk Tile
The REST API would be optimized for real-time, small queries. You request a dataset and SalesForce returns the results immediately. Probably has request limits and daily quotes. Use case would be for syncing a single object like pull all accounts or leads daily. For dashboards that don't require a bunch of historial data. i.e. "Give me today's updates."
The Bulk API would be optmized for large scale data extractions. It would create a job, process the request asynchronously, and return the data in chunks. This would handle big datasets (millions) more efficiently than the REST API. You won't get the data instantly because it runs the job to fetch the results. The use case would be for getting history for many years. Like event logs.
Re: Digital Chatter Challenge Winners π
Great news!
I'm happy to be able to participate in this event from Japan.
DOMO ARIGATO,Thank you @AnnaYardley and DOMO .
NRT
Re: New Navigation: Default View by User Group
A Company level Navigation list would also be useful. Specifically, a set of default items that would exist for all new users. Editable after they log in, but it would reduce confusion if the user doesn't have certain access and provide focus when first logging in. It would also allow for custom links to company websites to be added, such as to company IT support.
Marsha
Re: Timezones
You can use the CONVERT_TZ function to convert one timezone to another. You just pass in the field you're wanting to convert, the timezone the data is in and then the timezone you wish to convert to.
CONVERT_TZ(`Timestamp`, 'UTC', 'US/Central')
Re: YOY with Series
I don't think your going to find a simple solution. I think you have to get creative vs using Domo's YOY.
When I do year over year comparisons, I normally use formulas for creating dynamic values: CY, PY, and P2Y (Current Year, Previous Year, and Previous 2 Year).
For P2Y Year to Date, I'll use something like this:
sum(
case when YEAR(`date`) = YEAR(DATE_SUB(CURRENT_DATE(), INTERVAL 2 YEAR))
and `date` <= DATE_SUB(CURRENT_DATE(), INTERVAL 2 YEAR)
then `amount` else 0 end
)
The detail of the formula depends upon what I need to break out. Such as your instrument buckets. And if you need months, you create them dynamic or hard code such as AND MONTH(`date`)=1 for January.
Re: Can Net Income calculation be created in dataflow?
A BeastMode approach would be to change your FinData to be negative for expenses and positive for revenue. Then you could use the table's built in Total row, which has the advantage of being dynamic with filtering.
CASE
WHEN Account Type = 'Revenue' THEN FinData
ELSE -1 * FinData
END
