How to show Avg.

[#1]

Hi All,

I have field [Create Date Time] and [Close Date Time] i need to calculate Avg time for resolution.

( [Close Date Time] - [Create Date Time] ) / Count(Id)

How can i do this on the script level on the model.

Thanks

Bosc

[#2]

Thanks so if i want this difference in seconds then how can i go for this.

Thanks

Bosc

[#3]

Please reply jagan on this.

Bosc

[jagan]

Just give SS instead of DD.

LOAD

*,

Interval( [Close Date Time] - [Create Date Time], 'ss' )  AS DiffDays

FROM DataSource;

Regards,

Jagan.