Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good day All,
I have a question I created an expression to count the event activity for list of servers
I'd like to return servers where number of events for each server is greater than 150 event per week, but I'm not sure of the correct syntax.
I figured out the count and condition although I'm not sure where I should place the AGGR function or if there another way to have this!
=COUNT({<SERVER = {"=(COUNT(SERVER )>150"}>}SERVER )
if it was a table on DB it will be like this
SELECT WEEK,SERVER,count(SERVER) TOTAL
FROM TABLE
GROUP BY 1,2
HAVING count(SERVER) >150
Thanks in advance
May be this
Sum(Aggr(If(Count(SERVER) > 150, Count(SERVER)), WEEK, SERVER))
May be COUNT({<SERVER = {"=Aggr(COUNT(SERVER ),WEEK)>150"}>}SERVER )
Thanks Sunny
This good, although as we used IF it will return all the servers and for those servers which less than 150 event it will be 0.
I need to display only the servers with more than 150 not all!
Thanks Sasidhar,
This proposal will not show the events per each server it will display the servers with more than 150 event although the total # of event will displayed as 0 and will display the sum of servers
Thanks in advance
Sorry, I am confused and now sure I understand your concern?