Automated Indicator for Count of Demands Approved Per Day / Month

[D_ Taveras]

Hi, we are looking for an automated indicator that would tell us how many Demands are Approved each day, and then aggregate the information based on different calendar units (e.g., week, month, quarter, year).  This would give us the throughput for our Demand Management team, who are primarily responsible for shepherding the Demand through up to the Approval. 

Is there an existing standard OOTB indicator that provides this score?  Or does anyone have a way of creating this kind of indicator?  Anyone using something like this for a KPI?

Thanks.  

[Maik Skoddow]

Hi

you don't need any indicator as the table sysapproval_approver already has the information you need. Just filter the column "Source Table" for demands and then build a time series report.

Maik

[D_ Taveras]

That seemed promising, but the Source Tables that come up are change_request, dmn_decision, Pm_proj_task... and a few others.  None are the Demand Approvals.... 😞