Tried with Numofchanges but it also includes the count when valve changes from 1 to 0..
The valve usually remains closed and opens few times in a month.
Tried with Numofchanges but it also includes the count when valve changes from 1 to 0..
The valve usually remains closed and opens few times in a month.
Hello Shig11 ,
the Bom() function expects a timestamp as argument and will return the beginning of the month relative to the provided timestamp. For your purpose Bom('*') should work.
Hello Shig11 ,
the Bom() function expects a timestamp as argument and will return the beginning of the month relative to the provided timestamp. For your purpose Bom('*') should work.