Skip to main content
16-Pearl
Oct 5, 2018 8:00 PM UTC
Solved

Elapsed time.

Hi folks,

How to show/calculate time between first and last row in Data Table.
1-Visitor
Oct 6, 2018 7:30 AM UTC

DataTable or InfoTable?

 

Infotable:

var timeBetween = dateDifference(yourInfotable.rows[0][timestampField],yourInfotable.rows[yourInfotable.rows.length-1][timestampField]);

DataTable:

var yourInfotable = yourDataTable.GetGetDataTableEntries({ maxItems: 1000000 });
// -- Here the previous code, you may need to sort the yourInfotable by timestampField...

1 reply

1-Visitor
Oct 6, 2018 7:30 AM UTC

DataTable or InfoTable?

 

Infotable:

var timeBetween = dateDifference(yourInfotable.rows[0][timestampField],yourInfotable.rows[yourInfotable.rows.length-1][timestampField]);

DataTable:

var yourInfotable = yourDataTable.GetGetDataTableEntries({ maxItems: 1000000 });
// -- Here the previous code, you may need to sort the yourInfotable by timestampField...
Translate