Weird issue with average

[#1]

Hi All,

I am using the following in my load script(T-SQL)

SELECT OutboundCalls/(OutboundCalls+Inboundcalls)  AS Average_Calls

The numbers are in seconds. In my Qlikview table, am using th expression SUM(Average_Calls) as I need to be able to look at this by department or by agent. However, I need to show average for total.But it is not showing average. I have set the "expression total" option to "Average".

Fro example, for the following data, it showing the total as 5.07.

17.81

0.74

22.01

Any idea what is going on?

[nagaiank]

Try to load OutboundCalls and InboundCalls into Qlikview table and calculate the average in Qlikview.

[Anonymous]

Hi,

  Please take default as expression total,you will get average value only,if change at avrage it will give average of average value will be come.

Regards

[#4]

I want to do the caluclation in the script to enhance perfromance. So there is no way to do this?

[#5]

If I put the expression total, it sums the numbers

[Anonymous]

Hi,

  Can You please send the test application.

Regards

[erichshiino]

I agree with krishnamoorthy. You can't pre-calculate the average, because it would be very complicate to group or summarize it in your dimensions.

You can improve the performance just a bit pre-calculating the sum of inbound and outbound as total_calls.

Then, you use those three fields to calculate the average.

Regards,

Erich