Is it possible to see data on how many requests are being approved or rejected by each approver?

Mithun Mohan S
Tera Contributor

I would like to get to how many requests are approved or rejected by each approver who are part of approval assignment group. 

2 ACCEPTED SOLUTIONS

AndersBGS
Tera Patron
Tera Patron

Hi @Mithun Mohan S ,

 

For sure. Create a report based on the sysapproval_approver and at in below condition:

AndersBGS_0-1733837676026.png

Only reason that I have created on this month in the condition, is due to limit the amount of records.

 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

 

best regards

Anders

 

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

View solution in original post

Uncle Rob
Kilo Patron

Good use case for a pivot table (multi level pivot to be precise)
In this case I compared the Approval State against the Approver and the Task Type of what the thing was approving for.

UncleRob_0-1733839466781.png

 

View solution in original post

7 REPLIES 7

AndersBGS
Tera Patron
Tera Patron

Hi @Mithun Mohan S ,

 

For sure. Create a report based on the sysapproval_approver and at in below condition:

AndersBGS_0-1733837676026.png

Only reason that I have created on this month in the condition, is due to limit the amount of records.

 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

 

best regards

Anders

 

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

Thanks @AndersBGS - Look like your solution is worked. 

But will I be able to add additional filter in query for bringing the requests from particular group that are part of approvers. 

MithunMohanS_0-1733922817455.png

 

 

Hi @AndersBGS  - I'm unable to get complete requests details after I added approver group. Any suggestion that you can provide which would be grateful. 

MithunMohanS_0-1733924997802.png

 

Hi @Mithun Mohan S ,

 

What details can't you obtain? All details should be available if you dot-walk in the report from the sysapprover_approval table to the Approving/Approval for.

 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

 

best regards

Anders

 

 

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/