Need Avg for Each

[soniasweety]

Hi all,

I want to calculate count and avg hrs of each type of numbers  to particular .

attached excel with sample example.

can anyone suggest the way?

only some of the Type values to be shown.

Thanks

Sony.

[soniasweety]

Ok sunny,

Sunny Talwar

Thanks. till now that is working fine. let you know if anything change required.

small doubt. if I want to do on some other filter values how can I write?

means other field name is  group= '@oreta ', '@emea'    instead of  type   and I want dimension as type only?

here if I filter in data with above group only that group related types should display in table.

hope this is clear

Thanks

Sony

[sunny_talwar]

Not sure I understand... can you elaborate?

[soniasweety]

[sunny_talwar]

May be like this in set analysis

{<Group = {'Oreta', 'emea'}>}

[soniasweety]

in dimension I have given this

If(Wildmatch(Type,'Order', 'Server'),Type)

is it fine?  or it make any issue? or i can use direct Type as dimension?

[sunny_talwar]

It is usually more efficient to use set analysis rather than calculated dimensions, but what you just posted above should also work

[soniasweety]

Okay sunny thank you for clarification

Thanks

Sony