I have a series of endpoints that have hourly readings as well as a set of event times. A specific subset of the endpoints' readings are expected to drop during the events. I am trying to figure out a visualization that could identify the endpoints that do not align with this expectation.
Right now the dataset I have includes only the device ID, reading, timestamp, and whether or not the device is in this subset. I am thinking about appending the data with a field that indicates whether or not that reading occurs during an event. While this would help identify the readings that occur during an event, I'm still not sure on how to identify individual devices that fail to deviate as expected.
Is this even possible and if so, what are some good strategies to approach this with?