Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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