I am new to Ignition, and working with SCADA in general, and would like some pointers on good ways to approach a report i would like to build.
In the ControlLogix for one of our paint lines i have accumulating counts (using DINT not COUNTER) for skid throughput per job and shift, that get reset at 2AM. Want to do history for those for previous week. Our IT department has not set us up with a SQL database to use yet, so limited to SQLite. Was originally going to do a transaction group to save values to DB at 1:30AM, after production has finished but before daily reset, but having trouble with getting timestamp to show as a date, and with figuring out how to structure the data in the table to arrive at the report view desired (shown in attached excel). Not sure if i can use tag history, since COS would have a new data point at every increment instead of just the total, and i cannot tell it to only store between 1:30AM-2AM. Maybe create a new set of DINTs in PLC that just get written to at that time with the daily total?
Also not sure it is even possible or how to go about designing the report to display like that in Ignition. Any pointers greatly appreciated. I am very limited on my knowledge of Python, so any solutions involving scripting i may have some trouble understanding.
Thank you in advance.
Chart basis.xlsx (15.2 KB)