Re: Qlik Sense Script: how to evaluate if a Timestamp interval is less than "n" seconds
In fact you're right,
the problem could be the aggregations we have to make before to evaluate the delay in seconds for each group of timestamps.
The example below shows a data subset in which we have a delay of 1 second between "04.11.2017 07:00:00" and "04.11.2017 07:00:01", for all the aggregations ("DB_CONTABILIZZATORI_2_ET20-ENERGIA_TERMICA_ASSOLUTA_IN_VAPORE_USCITA_CALDAIA" is one of them).
We are transforming a set of csv files, extracted from Energy Machines PLCs every 15 minutes, containing the misure of many dimensions (the aggregations); sometimes the csv files are extracted twice for the same energy check with a delay within 5 seconds, and we have to monitorize this.