PriteshD

Filter Expression

Discussion created by PriteshD on Nov 29, 2019
Latest reply on Nov 29, 2019 by Vinit_J_shah

I am looking for options on filtering samples based on timestamp difference between two consecutive samples.

Tried few expressions but am getting syntax error.

 

Example :

I would like to get sample count for 'sinusoid' tag where timestamp difference between two consecutive samples is more than 100s.

(duration start :-24H, end : * )

 

Tried filter expression : 
Int(TimeStamp(TagVal('sinusoid')) - TimeStamp(PrevVal('sinusoid')))>100

Int(TimeStamp(TagVal('sinusoid'))) - Int(TimeStamp(PrevVal('sinusoid')))>100

Outcomes