Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hi,
Convert your reload Time into Min only then divide it by RowsLoaded will give avg per Min.
Regards,
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:
PFA a sample application for your reference:
Best,
Sunny