alert with set analysis

[#1]

hi all

i wont to create alert , i think its with set analysis

the alert need to show me by this conditions

1.counter that bring me the result, like sum(x)/sum(y) <97%

and

2.diemension is machine name

the alert must to be together 1+2

thanks

[#2]

i need also to know the last date change only, but to check all the dates in the sql 

[#3]

i need also to know the last date change only, but to check all the dates in the sql 

[#4]

someone?

[#5]

Alert won't work dimension wise..

But if you want check condition on machine wise then you can use aggr() like below.

=Min(Aggr(Sum(x)/Sum(y),[Machine Name]))<0.97

Hope it helps..

[#6]

KARTHIKS THANKS

THIS FORMULA GIVES ME THE LAST DATE ONLY

OR THE ANSWER ABOUT ALL THE DAYS

I NEED TO CHECK ALL THE DAYS BUT TO SEE THE CHANGE ONLY IN THE LAST DATE

BR

[#7]

The above experssion will calculate Sum(x)/Sum(y) on machine wise and If any single machine (Sum(x)/Sum(y))

go less than 97% means then it will throw alert message..

If you want to do same calculation for Machine wise and Day wise means then small change required on expression.

Like below,

=Min(Aggr(Sum(x)/Sum(y),[Machine Name],[DateField]))<0.97

If possible, please share sample file ..

Karthik

[#8]

THANKS AGAIN

HOW I GET WITH DATE FIELD,

ONLY THE LAST DATE CHANGING?