I have tags that record if a department is meeting their production target. (% of orders complete within 7 days of the due date)
I want to save a snapshot of this tag on the midnight of the 7th day of the month as the score for the previous month. At which point the tag starts showing data for the next month.
Essentially I want the table to look something like this:
2023 June 100% (Saved 7th of July)
2023 July 85% (Saved 7th of August)
2023 August 100% (Saved 7th of September)
...
Is it possible to use the historian to save the value of a tag on a specific date (7th of the month), but either backdate the entry for the previous month or save the value (Percentage) along with a second value (Month) as context?
Or is the historian the wrong way to do this and I should just write a scheduled script to my own database table to handle this?
I haven't purchased the historian module yet and am wondering if could be used in this situation.