How does alert work

[#1]

Hi,

I have create the following table.

LOAD * INLINE [

  Salesman,NoOfProducts,year,total

  Sujeet,12,2012,1000

  Smita,10,2011,100,

  Hari,5,2010,50

  Bala,20,2012,1000]

After that i tried to create an alert with the condition "sum([TOTAL]<100) ". I am expecting something like if i reload the table and click on the row where total is 50, i should see the alert message. But I am not able to see anything. Please let me know the best use of alerts.

Next question is from my desktop how can i send the alert to my GMAIL ?

Thanks,

Sujeet

[erichshiino]

Hi,

The condition will be tested during reload. In your case, you compare the result of all of them ( 2150) with 100... and it doesn't satisfy the condition ( and it should be sum([total) > 100 instead of sum( [TOTAL]<100)

You need use aggr in the expression to test each of the Salesman to identify if any of them had sum( ...) <100

the condition will be

sum( aggr( if( sum( [total]) <100,1,0), Salesman))>0

Hope it helps,

Erich