Reporting on saved goals

Summary

Reporting on a goal before it's been approved by the manager

Content

Hello,

We used to be able to report on goals using Goal Status Overview Real Time. The Version Type filter used to tell me whether a goal was "Active" to mean it was submitted. Sometime in the past year and a half's worth of releases goals were moved into the transactions area.

I believe there's a way to use logical SQL to pull these together but I wasn't able to find instruction on here. We're trying to pull together a status for the goal setting campaign and since losing the ability to see saved but not approved goals we're limited to reporting on workers who haven't started the campaign and those that are done.