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
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
Helper 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.