I have a request for the following:
- A user would like a report returned when the Volume is the same over 5 intervals (by hour)
- When the values for Volume are the same for 5 consecutive hours, return it in the report. (This is an exception report, seen as a negative)
Volume is an integer field
Hours is an integer field
Date is a date time
I was looking at the interval function. I'm a bit confused in the best approach. Can someone recommend something?