please suggest

[#1]

Hi

i need to show the count of the devices whose status is DOWN

Server	Timestamp	Status
A	3/19/2015 17:29	DOWN
A	3/9/2015 14:09	Maitenance
B	3/2/2015 14:09	Intransit
C	7/29/2015 1:29	DOWN

So according to the above table the device count count should be 2 but i have to ignore the DOWN status of Server is the server has atleast one more record as Maintenance so going by this Server A should not be considered as DOWN and should get only Server C as down

[gautik92]

count({<Status={'DOWN'}>}Server)

[sunny_talwar]

Try this:

=Sum(Aggr(If(Count({<Status = {'DOWN'}>} Status) = Count(Status), 0, 1), Server))

[nagarjuna_kotha]

Hi Try THis:

=count({<Status={'DOWN'}>}Server)

[#5]

I want to show only Server C as this has only DOWN Status but Server A should not fit in the requirement as if  a Server has a Maintenance Status as well as DOWN Status so that particular Server should not be considered as DOWN.

[#6]

=count({<Status={'DOWN'}>}Server)

this will use set analysis to only count the items (server) that have a value of 'DOWN' in the Status field

[sunny_talwar]

If you want to show only C as down, try this:

=Sum(Aggr(If(Count({<Status = {'DOWN'}>} Status) = Count(Status), 1, 0), Server))

and to see which one was down, try this:

=Concat(Aggr(If(Count({<Status = {'DOWN'}>} Status) = Count(Status), Server), Server))

[jonathandienst · Accepted solution]

Like this?

count({<Status={'DOWN'}, Server = E({<Status = {'Maintenance'}>} Server)>} Server)

[shair_abbas]

hope it will work if you want to show only count

count({<status={'DOWN'}>}server) - count({<status={'Maintenance'}>}server)

[#10]

Thanks Jonathan, It worked