Change Notice State reporting

[cmckenna]

Hi,

I'm looking to build a report that gives me the number of days spent at each state for each Change Notice. Can anyone recommend how to do this using functions within the Query Builder?

Thanks

[JeffZemsky]

Conor,

This example is based upon older screenshots, but the methodology is still the same.

Query Builder Lifecycle History Example