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
- 10.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 470 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 193 Visualize
- 252 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
- 174 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive