Average representation in Bar Chart

[#1]

Hi,

I want to represent avaerage of a column in bar chart, below is the requirment.

I am loading data from excel file where I am having 3 columns, 1. Request Number, 2. Request Owner , 3. Request group.

I need the average of lists handeled by team as well as by individual request owner in bar chart. Below is the sample data.

Request Number	Request Group	Request Owner
300-12696	BUSAPPS-ABC	abhi
300-12697	BUSAPPS-ABC	Raj
300-11872	BUSAPPS-ABC	abhi
300-12032	Busapps-XYZ	Abhi
300-12057	Busapps-XYZ	Sam
300-12014	Busapps-XYZ	Sam
300-11470	Busapps-XYZ	Joy
300-8867	Busapps-XYZ	Roy
300-9017	Busapps-XYZ	Sam

Can anyone please help me with this?

Thanks in advance.

Regards,

Abhi

[#2]

Hi Can anyone please help me on this, its quite urgent.

Thanks in advance.

Regards,

Abhishek

[tresesco]

Your input is understood. Could you post the expected output as well?

[#4]

Hi Tresesco,

The output is nothing but the average of request number handled by group Vs average of request number handled by request owner.

E.g. if there are 50 requests in a group and I handled 17 out of 50 and we have 4 people (include me) in team then I want average of complete 50 request handled by team Vs average of 17 request handled by me and want to represent it in a graph.

Thanks,

Abhi

[sundarakumar]

Hi Tresesco,

Hope the attachment will help...

Sundar