Need Help??

[paulwalker]

Hi Community,

i have one table like this..

START DT/TIME            END DT/TIME                    Reload Time      RowsLoaded              Avg Per Min      

05/14/2015 00:15:35        05/14/2015 00:16:00            00.01.25                  80

05/14/2015 08:15:35        05/14/2015 08:16:00            00:01:12                  70

I have  calculated Reload time between startdate and enddate.

Here, how to calculate Rows Loaded per Min?

[PrashantSangle]

Hi,

Convert your reload Time into Min only then divide it by RowsLoaded will give avg per Min.

Regards,

[sunny_talwar]

Try this:

Table:

LOAD *,

  RowsLoaded*60/Num(Num#(Interval(ReloadTime, 'ss'), '##')) as [Avg Per Min];

LOAD * INLINE [

    ReloadTime, RowsLoaded

    00:01:25, 80

    00:01:12, 70

];

Output:

[sunny_talwar]

PFA a sample application for your reference:

Best,

Sunny