Reporting on a "As Of" Date - Any Suggestions?
SummaryTrying to leverage an existing data field/derived field to calculate an as of date to report on historical data and get a snapshot of data at a point in time.
I have attempted to use this type of data field in numerous reports such as funnels, open/filled requisitions, openings per recruiter etc. The goal is to be able to get a snapshot in time of X amount of requisitions and/or openings to analyze trends over time. I have gotten close by leveraging pre-existing data items in OBIEE, however, it always seems to affect the correct number of data that should be returned.