Reporting on Posting Dates and Sites (also filters?)
This is my first time submitting a question. I tried searching around for the answer but couldn't find it.
I want to run a report that lists each posting date to each career site, as well as each unposting date on each career site. I need each of these items to be reported as their own row.
I've attempted this by combining the follwing fields:
- History - Creation Date
- History - History Text
- Requisitions - Req Number
- Requisitions Client (client is our alias for the default location field - long story)
Since I don't need (nor do I want) every item in the History Text column, I thought I would filter this column to include only rows that contain "*post*" in the History - Text column (i.e. only rows that contain "post" in the History Text column).