I'm developing a system that will be deployed multiple times for multiple clients, and with the testing I bumped into something that I'm not sure if it has already been solved, so first I would like to apologize if it has.
Turns out I had to disable a data source while some renovations were made and, when I enabled it again, I didn't realize that 2 data points were logging wrong values because the sensors linked to them were disconnected. Now, when performing statistics analysis, those wrong values make the average and the minimum value go wrong.
Today, I was looking all over the new and old UI for an option to easily fix this couple of hours period (setting the wrong logged values to the last correct value); I haven't been able to find an easy way. The only way I found that I think would make this possible is with an SQL update submission but, since the corruption risk seems to be high, I was wondering if there was an easier way to do this.
I hope this exists, because I can already see this happening with our clients a lot; maintenance technicians always do whatever they please even if they don't know what they're doing. In a system that we installed prior to using Mango this was a very common occurrence, and I wouldn't like to risk corrupting the database every time I need to fix values.
Thanks in advance.