Loading

LASTSORT

gts

Sorts a list of Geo Time Series™ according to their most recent value. If most recent values are identical, ticks will be compared, the most recent appearing first. If the ticks are also identical, then metadata will be compared, classname first then labels then attributes.

When comparing on metadata, labels and attributes lists are first sort in a lexicographic order, then label values are compared when label names match. Same for the attributes

Use this function to compute Top N queries.

LASTSORT is available since version 1.0.0.

Signatures

Examples

[ NEWGTS 'gts-0' RENAME 0 NaN NaN NaN 0 ADDVALUE 2 NaN NaN NaN 2 ADDVALUE 3 NaN NaN NaN 3 ADDVALUE NEWGTS 'gts-1' RENAME 10 NaN NaN NaN 1 ADDVALUE 30 NaN NaN NaN 3 ADDVALUE NEWGTS 'gts-2' RENAME 100 NaN NaN NaN 0 ADDVALUE 300 NaN NaN NaN 3 ADDVALUE NEWGTS 'gts-3' RENAME { 'label1' 'a' } RELABEL 100 NaN NaN NaN 0 ADDVALUE 300 NaN NaN NaN 3 ADDVALUE ] LASTSORT

Examples

gts0 = NEWGTS() RENAME(gts0, 'gts-0') ADDVALUE(gts0, 0, NaN, NaN, NaN, 0) ADDVALUE(gts0, 2, NaN, NaN, NaN, 2) ADDVALUE(gts0, 3, NaN, NaN, NaN, 3) gts1 = NEWGTS() RENAME(gts1, 'gts-1') ADDVALUE(gts1, 10, NaN, NaN, NaN, 1) ADDVALUE(gts1, 30, NaN, NaN, NaN, 3) gts2 = NEWGTS() gts2 = RENAME(gts2, 'gts-2') ADDVALUE(gts2, 100, NaN, NaN, NaN, 0) ADDVALUE(gts2, 300, NaN, NaN, NaN, 3) gts3 = NEWGTS() RENAME(gts3, 'gts-3') RELABEL(gts3, { 'label1': 'a' }) ADDVALUE(gts3, 100, NaN, NaN, NaN, 0) ADDVALUE(gts3, 300, NaN, NaN, NaN, 3) return LASTSORT([gts0, gts1, gts2, gts3])