Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Like this?
count({<Status={'DOWN'}, Server = E({<Status = {'Maintenance'}>} Server)>} Server)
count({<Status={'DOWN'}>}Server)
Try this:
=Sum(Aggr(If(Count({<Status = {'DOWN'}>} Status) = Count(Status), 0, 1), Server))
Hi Try THis:
=count({<Status={'DOWN'}>}Server)
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.
=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
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))
Like this?
count({<Status={'DOWN'}, Server = E({<Status = {'Maintenance'}>} Server)>} Server)
hope it will work if you want to show only count
count({<status={'DOWN'}>}server) - count({<status={'Maintenance'}>}server)
Thanks Jonathan, It worked