Best Of
Re: Can I filter by latest date?
@damen, This can be accomplished with the rank and filter tiles.
Simply rank the dataset by date descending and keep only rank #1 in your filter tile.
nmizzell
Re: Data Import Help
Are you able to monitor the network traffic in an effort to sniff which APIs it might be calling and then use those APIs?
The cleanest option you have with your excel file would be the ctrl+v paste option into a local excel file that you upload then you can use Magic ETL to convert the data types and clean the data.
Calculated Field loses Percentage Format
CASE
WHEN SUM(Total Weight/Units Received) > SUM(Weight (MIN)) AND SUM(Total Weight/Units Received) < (Weight (MAX)) THEN '1'
WHEN SUM(Total Weight/Units Received) <= SUM(Weight (MIN)) THEN SUM(Total Weight/Units Received/Weight (MIN))
WHEN SUM(Total Weight/Units Received) >= SUM(Weight (MAX)) THEN SUM(Total Weight/Units Received/Weight (MAX))
END
The THEN '1' seems to be breaking the ability to display the resulting column as a %. Even when the format is set to Percentage, the column appears a follows.
Re: Schedule App Studio Reports
Upping this! Our team is really looking forward to seeing this feature live.
Re: Beast mode question
How about using DAYOFWEEK(last_update) NOT IN (1, 7) to make sure only weekdays are used?
SUM(CASE WHEN DAYOFWEEK(last_update) NOT IN (1, 7)
AND last_update BETWEEN DATE_SUB(CURDATE(), INTERVAL 15 MONTH)
AND CURDATE()
THEN 1
ELSE 0
END)
/
COUNT(DISTINCT CASE WHEN DAYOFWEEK(last_update) NOT IN (1, 7)
AND last_update BETWEEN DATE_SUB(CURDATE(), INTERVAL 15 MONTH)
AND CURDATE()
THEN CONCAT(YEAR(last_update), MONTH(last_update), DAY(last_update))
ELSE NULL END)
Re: DomoStats Alerts Subscribers
@thaddeusbudde A current workaround for this would be to use the JSON no-code connector to create your own DomoStats report to show who all is subscribed to an alert.
If interested, you can hit this endpoint GET https://domo-community.domo.com/api/social/v4/alerts?all=true&fields=all&limit=15&offset=0
Domopalooza Workflows Feature Release
We are excited to announce new Workflows enhancements.
Workflows is a low-code logic-building tool that allows you to streamline data-driven processes and spend less time on complex business activities. With Workflows, you can automate routine tasks to increase operational efficiency; orchestrate steps and actions; and integrate users, data, and logic across any enterprise SaaS platform outside Domo.
Here’s what’s new for Workflows!
Mobile Task Manager App
The new Mobile Task Center App provides access to queue and task capabilities previously only accessible in a desktop experience. Tasks are efficiently organized into queues to easily monitor, update, and submit through your mobile device, allowing you to view queues and complete manual tasks on the go!
To learn more, read the current release notes.





