Is it possible to create one variable from archive?
Today I am developing a new functionality to existing project in zenon. I would like to store one archive value, from few days before today to new variable in zenon. The reason to do that is that I I have a project with about 50 water meters and I want to check if there were no consumption in few days (for eg. 3,4 or 7 days) which could indicates problems with meter (cause there is always some water consumption). Each meter actual reading is stored to archive every 24 hours. In SQL I will do that for example in that way:
SELECT Value from Table WHERE Date = dateadd(day,datediff(day,3,GETDATE()),0)
To explain problem more carrefully I will show an example:
Day of week - Meter Reading [m3]
Monday - 150
Tuesday - 150
Thursday - 150 [Check if Thursday(actual) value is = Monday value, if it is true show an error] - error
Friday -150 [Check if Friday(actual) value is = Tuesday value, if it is true show an error] - error
Saturday -165 [Check if Saturday(actual) value is = Wednesday value, if it is true show an error] - no error
Sunday - 165 [Check if Sunday(actual) value is = Thursday value, if it is true show an error] - no error
Is it possible in zenon or maybe I need to prepare VBA macro for that? Or maybe there is another solution for this?
This is a migrated post! Originally posted on 14.12.2018 by user michalt. Please be aware that information can be outdated.