how to calculate average value

[francis_gr]

Hi All,

I need to add a column in the sample chart to calculate, for each time, the average value of all the operations done for every office at that time

thanks

[sunny_talwar]

Not sure what your requirement is, would you be able to tell what your expected output is?

Best,

Sunny

[sebastiandperei]

Use avg instead of sum

[MarcoWedel]

Hi,

maybe like this?

hope this helps

regards

Marco

[francis_gr]

Hi Marco!

Thanks for your response.

That's fine but i need a bar chart to show the avearge operations. when i change the chart type from combo chart to bar chart, the average column is over the office`s bars but i neeed to show the average operatios (by time) in a new column.

regards

[francis_gr]

Hi Suni!

Thanks for your reply

As I told Marco, the main problem here is that when i change the chart type from combo chart to bar chart, the average value is over each office`s bar but i neeed to show the average operations done by the two office in that time

please, take a look to the attached file

Regards