Setting custom alerts based on calculations
Hello,
I've created the chart below where the line represents the running total number of sales and the bars represent the forecasted sale throughout the day. Would it be possible to create an alert that notifies users when the sum of sales is equal to or greater than the max forecasted sales value? Basicly setting an alert with forumlas rather than a hardcoded number. I thought about setting a binary field in the data to set off a trigger but then it seems as if it would have to be incorporated into the chart.
Emilio
Comments
-
Hi all,
Can anybody help @eizquierdo out?
Thanks!0 -
@eizquierdo: Very cool use case! I'm the product manager for alerts here at Domo. Just to make sure I understand, you're essentially setting a daily sales goal target. When your sales for the day go over the goal, the alert would trigger. In this case, you'd like that goal to be the max value from the Sales Forecast series. Something like this?
Retired Domo Alum1 -
@mdelorey Correct! When the total number of sales for any given day is equal to or greater than the total number of sales forecasted for the day, I'd like for an alert to be triggered. The catch is that the total number forecasted for a day changes everyday, therefore we can't hardcode a number to meet or excced.
I had the idea of creating a seperate dataflow/card with a value of 1/0 if that number is met and attaching the alert to that. However I'd like to stay away from something like that as best as I can. Less cards, less maintance.
Thanks for the help.
-Emilio
1 -
Thank you @kshah008
2 -
@eizquierdo: Sorry I must have forgotten to hit post on my last reply. My thoughts were along the same lines as yours. Do the comparison in a dataflow or beastmode and then alert on a new card. All the solutions in the product today would be workarounds.
However, I've gotten interest from other users to be able to set alerts based on values seen in the chart like your forecast/target/budget vs actual. It's a great use case, and I'll keep you posted as we get closer to prioritizing it on our roadmap. Thanks!
Retired Domo Alum3
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 623 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 748 Beast Mode
- 60 App Studio
- 41 Variables
- 690 Automate
- 177 Apps
- 455 APIs & Domo Developer
- 48 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 397 Distribute
- 114 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 127 Manage
- 124 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive