Forum Discussion

Gazi's avatar
Gazi
Frequent Visitor
8 years ago
Solved

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 ther...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    8 years ago

    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)
Anonymous's avatar
Anonymous
Not applicable
5 years ago

How could we apply this at a monthly level for eg. sales at monthly level with alerts for a salersperson if the number dips below a certain threshold ?

 

Name    Jan    Feb   Mar

A           100    125     85

A           110    105     95

A           100      95     100