We have an OBIEE dashboard that is used to basically count the number of widgets we produce a day. This dashboard is displayed on a console that is updated every 5 minutes or so to the floor supervisors. The problem we have ran into is working the filter work with our plant's false midnight. For example our plant day is from 0500 to 0459 the next morning. Does anyone have any hints as to how to setup the filter to handle only searching for data that occurred on the current day between those times?
Plant day would be from April 1, 2016 0500 until April 2, 2016 0450.