Need Help

[#1]

@I need to find out how many server having windows OS are having average of usage above 45 .

Server	OS	Date	Usage
A	Windows	5/20/2016	40
B	Windows	5/20/2016	21
C	UNIX	5/20/2016	44
D	Windows	5/20/2016	68
A	Windows	5/21/2016	54
B	Windows	5/21/2016	23
C	UNIX	5/21/2016	11
D	Windows	5/21/2016	34
A	Windows	5/22/2016	78
B	Windows	5/22/2016	34
C	UNIX	5/22/2016	12
D	Windows	5/22/2016	45

When we create a chart with average of usage for server having windows OS we get the following chart

Server	OS	=Avg({$<OS={'Windows'}>} Usage)
		44.111111
A	Windows	57.333333
B	Windows	26
D	Windows	49

Now here in the above chart server A and D are having average usage above 45 . Can we get the count of the Server in having above 45 usage in displayed in a Text. The desired output is 2 but not sure how can we display this in text box

Message was edited by: Binod Kuma

[PrashantSangle]

Hi,

try like

sum(if(aggr(YourAvgExpression,os,server)>45,1)

edited:

=Sum(aggr(if(Avg({<OS={'Windows'}>} Usage)>45,1),OS,Server))

This will work

Regards

[#3]

=if(aggr(Expression,os,server)>45,avg({<os={'Windows'}>]usage)

[Anil_Babu_Samineni]

Like this, Or tell me what you are expecting

[sujeetsingh]

Can you please give a sample or come in more words.

[Kushal_Chawda]

try below expression in text box

=Count({<Server={"=avg({<OS = {'Windows'}>}Usage)>45"}>} distinct Server)

[kamal_sanguri]

Hi,

take a look into attached file..

-Kamal

[#8]

Hi,

try this one

=Count({<Server={"=avg({<OS = {'Windows'}>}Usage)>45"}>}Distinct Server)

-Joyson G

[Anonymous]

Hello kamal

Your expression is correct . Only >45 as underlined below should be used as per requirement

Only thing is count({<OS={'Windows'},Usage={'>45'}>}Server)

Dear Binod Kumar

If you can mark correct answer if your issue is resolved it would help other members.

Thanks & Regards

Chintan

[kamal_sanguri]

oops, I think, I didn't understand the problem at first place..

I did this in script..

Pls have a look.