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 toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.0
Categories
- 10.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 472 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 198 Visualize
- 254 Beast Mode
- 2.1K Charting
- 11 Variables
- 17 Automate
- 354 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 247 Distribute
- 63 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 178 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive