topic Re: Avg line! in QlikView

Avg line!

Wed, 25 Nov 2020 16:16:04 GMT

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 — Thu, 06 Oct 2016 02:28:10 GMT

May be like this:

Sum(TOTAL Count)/Sum(TOTAL Hours)

Anil_Babu_Samineni — Thu, 06 Oct 2016 04:30:08 GMT

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 — Thu, 06 Oct 2016 05:36:43 GMT

Hi,

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