I am currently working on a driver that queries and stores a historical log e.g. a log of packet drops incidents. Each incident is stored as a separate instance (PK) and states the source IP and destination IP.
The user would like to be able to trend the packet loss between 2 IPs over time (i.e. y-axis is the packet loss values, x-axis is time).
Is there an elegant method to do this from the existing table?