Forum Discussion
Data Alerts for each row
Hi everyone!
I need to create an alert for each row in my dataset, whenever any of them goes below 5.
Currently i have 85 rows, i could create 85 visuals for each, but how to handle when there is a new row in the dataset?
I know it's a bit weird approach, maybe someone has a better idea?
Many thanks!
Gazi
Create a measure like this and set a notification for > 0
BelowFive = VAR myCount = COUNTROWS(FILTER(Table,[Column]<5) RETURN IF(ISBLANK(myCount),0,myCount)
9 Replies
- Greg_Deckler
Community Champion
Create a measure like this and set a notification for > 0
BelowFive = VAR myCount = COUNTROWS(FILTER(Table,[Column]<5) RETURN IF(ISBLANK(myCount),0,myCount)
Thank you Greg_Deckler!
It actually worked! :)
But is there any way to see relevant row's data? i mean which row triggered it (it contains project names)
- Greg_Deckler
I believe that you can only set alerts on numeric data so it wouldn't work to concatenate all the project names rows together which was my first thought. Glad it worked though!! If I come up with something I'll let you know.
Hi I am just wondering is that possible to set an alert and get the relevant project name?
Thanks a lot!
