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
- 300 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 616 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 738 Beast Mode
- 56 App Studio
- 40 Variables
- 685 Automate
- 176 Apps
- 452 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 123 Manage
- 120 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive