đź‘‹ Use this site to provide feedback and ideas for all Nintex Products. See our post on Nintex Community "Welcome to Nintex Ideas" for more details on Nintex Ideas, how an idea is handled by our product teams and more!
If you have questions about Nintex Ideas, please contact ideas@nintex.com
If you require support, please visit Nintex Customer Central
If you have a sales inquiry, please contact sales@nintex.com
The historical view of process state is already included in the reporting API, in the ProcessesHistorical table. My organisation currently uses the data in this table to extract similar metrics to what you are mentioning.
For example, we have a report that shows all processes for a business area, with a metric of the number of days that process has been in progress for those processes that aren't in a published state. To get this metric we use the ProcessesHistorical table to look up the first minor version (x.1) of the current major version that process is at, and compare its 'StatusChangeDate' field to today's date.
For approval/publish timeframes you would be able to do similar - look up the first minor version that a process is in 'awaiting approval' or 'awaiting publish' status for that major version. You then compare these dates to each other or the next publish date to get your timeframes.