Sum of Fields

[Anonymous]

Hi

i have 3 fileds Copy Time, Build Time, Sync Time with different values , How do i get the average of total of these times..

I have tried below expression for a chart to add a reference line of total avg duration...below but did not work ..Please Help..

= avg(sum ( buildtime,synctime,copytime))

[disqr_rm]

Until you get better and smarter way to do this, enclosed should give you idea of getting this done in a way.

Hope this helps.

[Anonymous]

I want to show my QVW ...how do i send?

[Anonymous]

My data is in minutes :

For Eg:

BuildTime - 60

CopyTime-20

Complie Time - 10

So i have to have a reference line in the chart which shows - 30 in the graph

Please let me know how do i write an expression for that??

[suniljain]

Dear Ramya,

You can also develop logic at script level it will reduce complexity at design level,

(BuildTime+CopyTime+CompileTile)/3 as Avg_Time.

and use Avg_Time on Chart.

Regards

Sunil

[shumailh]

While your reply you can go to option tab and add your attachement to share your qvw file.