Avg line!

[#1]

Hi!

This is a productivity calculation for each date!

I simply divided 'count' for each day by 'hour' for each day.

I want to have a reference line that will have overall productivity.

if I just use a trend line avg selection, it just gives back the avg of data points for each date.

but that's not what I want.

I want entire counts for all days divided by entire hours for all days and have a line that goes across the table horizontally.

if I could put in a line that is free from effect of dimension, it will solve the issue.

but i guess there could also be other ways.

Please help!

thank you in advance!!!

David

[sunny_talwar]

May be like this:

Sum(TOTAL Count)/Sum(TOTAL Hours)

[Anil_Babu_Samineni]

I simply divided 'count' for each day by 'hour' for each day.

For Single Day What you've tried. i mean which expression you've written.

[stabben23]

Hi,

you can use referenceline here to have a line a cross the chart.