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)
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
8 years ago

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.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Greg,

do you have already a workaround regarding the data alert with data name (like the project name in this example)?

Thank you in advance.

  • RemiAnthonise's avatar
    RemiAnthonise
    Icon for Helper V rankHelper V
    7 years ago

    Hi Greg Greg_Deckler , I need some help regarding these data alerts. I've also started a new topic for my issue here.

    I've made a measure following your help.

    Notification =
    VAR myCount = COUNTROWS(FILTER(SickEmployees;([Days sick]>=2)))
    RETURN IF(ISBLANK(myCount);"None";myCount)

     

    What I think it should do: it counts all rows where 'days sick' >= 2. I get 'none' beceause it's blank. If I change the measure to >=1 it gives me 74. The sum of days sick.

     

     

    What I expect / want: I want to get a notification when someone is sick for >= 17 days. So the measure should be changed to

    VAR myCount = COUNTROWS(FILTER(SickEmployees;([Days sick]>=2)))
    RETURN IF(ISBLANK(myCount);"None";myCount). But like I said, this gives me 'none'.

     

    You can find the sample file here in my Dropbox.