need help on alerts condition

[vishalgoud]

Hi Community,

I need a help on alerts condition..here is my problem.

i have three fields

1.ticket no(two types like "1234567" and "638738")

2.ticket actual effort hours

3.ticket approved hours.

now my requirement is to display alert where the ticket no starting with "12 "and if any ticket's effort hours are greater than of 85% of approved hours.

Thanks in Advance.

[Anonymous]

Take A chart object

and add ticket no as Dimension
and use below Expression

if(sum({<[ticket no]={'12*'}>}ticket actual effort hours)>(ticket approved hours*0.85),sum({<[ticket no]={'12*'}>}ticket actual effort hours))

[sunny_talwar]

Never used alerts before, so I unfortunately disregard my responses and I hope someone else will be able to help you.

Best,

Sunny

[vishalgoud]

Hi Bhagirath,

Thanks for the response,but i need to write the condition in alerts window for displaying a pop up message

[jagan]

Hi,

Try like this

LOAD

*,

if(wildmatch(ticket_no,'12*') and actual_efforts/approved_hours >= 0.85, 1, 0) AS AlertFlag;

LOAD

ticket_no,

actual_efforts,

approved_hours

FROM DataSource;

Now in Tools -> Alerts -> Add -> Condition

=Sum(AlertFlag) > 0 and give your message

Hope this helps you.

Regards,

Jagan.

[vishalgoud]

Hi Jagan,

Thanks for ur reply.

Isn't it possible to write a condition directly in alert condition, because my script is bit confusing to write the statements those u mentioned.

[pokassov]

Hello!

Can you check?

Sergey

[jagan]

Hi,

Try this expression Alert

=Sum(Aggr(if(wildmatch(ticket_no,'12*') and actual_efforts/approved_hours >= 0.85, 1, 0), ticket_no)) > 0

Hope this helps you.

Regards,

Jagan.