Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Not sure what your requirement is, would you be able to tell what your expected output is?
Best,
Sunny
Use avg instead of sum
Hi,
maybe like this?
hope this helps
regards
Marco
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
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