Alert - Most Recent Closed Month
Hey Dojo friends,
I'm looking to setup a followable alert for most recent closed month.
Background: We currently have a flag in the data "Yes" or "No" for "Is Month Closed". Right now I have a text card displaying the most recent month where the flag = 'Yes'. What I'd like to do is get an alert that triggers when the most recent closed month changes from month to month. (In the current case, most recently closed was July, I want to get an alert when the card displays August).
I don't want to have to display a numeric value on the card (or any card) to setup the alert if possible.
Any ideas?
**Please mark the post that solves your problem as 'Accepted Solution'
Comments
-
Here's the only way I've been able to get an alert to trigger without including any number values in the visual, maybe this will get you started in the right direction:
1. Instead of having 1 dataset with your months and Yes or No flag, break it into a new dataflow so that your current dataset populates an "Only Yes" dataset. Use this for your visual.
2. I did a Descending Month sort on my text card to get the most recent month in from the new dataset.
3. On my alerts, I chose "Any Item" and "Changes Rank". This way anytime a new "Yes" gets added by the dataflow, the items rank is updated and you get an alert.
Hope this helps!
**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the thumbs up if this post helped you.2 -
Thanks @Valiant I'm going to give it a shot and let you know if it works!
**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 296 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 53 App Studio
- 40 Variables
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive