You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Maximum Historical Status of a Req as of a point in time

Question
2
Views
0
Comments

Summary

We want to know what the maximum historical status of each Req as of the beginning of each month

Content

We want to know what the maximum historical status of each Req as of the beginning of each and every month.  If a req went into Sourcing status in Jan then filled in Apr, I will only see 2 rows of data.  One for Jan and one for April.  I want to see Feb and March with status of Sourcing as well.  The reason why is because we want to build a line chart to see the number of reqs we had in any open status for every month in the year.  The data is point in time so we need to

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!