Is it possible to create an alert with a values lies in two column?
Hi,
I'm trying to create an alert by comparing two values lies in two columns.
Here is the example
Date column A Column B
Jan 7 88 90
I want to set up an alert , when Column A < Column B and the message should be coming as
'On Jan 7 , the Column A value was 88 and Column B value is 90'
I have tried for different chart type, none of it is giving an option to select the columns of our own.
Kindly help with a solution
Any help is appreciated.
Thanks
Salma
Answers
-
Alerts aren't set up to compare one column to another. You may need to perform this evaluation in a beast mode to create a single value that you can check to see if it is greater than zero, for example, when creating the alert. This previous thread sums up the alert limitations pretty nicely.
https://dojo.domo.com/discussion/30912/alerts-functionality
Alert functionality is driven on the card type and settings. For example, a table card can only track changes to the summary number and so it is the only element that can be alerted for. Bar charts can track changes to values for the x/y axis and/or series. There is a balance to getting a card built right such that it will allow you to alert the value you want to see.
Often the card you use on the dashboard is not built the right way for alerting. In these cases you'll have to create a second card for the alert. It might not even be useful as a visual, but it is set up to be useful for alerts.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.0
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
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 748 Beast Mode
- 59 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 396 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 125 Manage
- 122 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