RSA IGL Version: V 7.2.x
Modules: Governance
Product Area: Charts, Multiple Series - Dynamic (Applied to Review Results Object Dashboard)
Associated Dashboard: https://community.rsa.com/docs/DOC-115123
Time to apply: ~20 minutes
This chart provides key information about the reviewers who have the most outstanding items left to be completed. It is a dynamic chart.
The goal of this chart is to understand which reviewers might need some help/focus, to get the review completed.
The chart can be used by Review owners or the admin team to better understand which users to contact and support during the review process.
This chart will only work when it is applied dynamically to the Review Results object dashboard.
This chart will show the top 10 reviewers, with the highest number of review items outstanding, which still need to be completed.
The chart shows both how many items the reviewer has completed already (if any) and their total amount still outstanding.
The following value needs to be used when creating the chart, however the value will update dyncamilly when used within the dashboard.
How to find an Example Target Object ID:
First test this in your query tool (SQLDeveloper, Toad etc..)
(
select
pU.First_name || ' ' || pU.Last_name as Reviewer_Name,
t1.Outstanding_Items,
t1.Completed_Items
from
(
select
Tcov.COVERING_USER_ID,
COUNT(1) as Total_to_Review,
COUNT(1) - COUNT(decode(IS_REVIEWED , 'False', NULL, 1)) AS Outstanding_Items,
COUNT(1) - COUNT(decode(IS_REVIEWED , 'True', NULL, 1)) AS Completed_Items
from avuser.pv_review_component Tcomp
join avuser.pv_review_coverage Tcov
on Tcomp.id = Tcov.REVIEW_COMPONENT_ID
where Tcov.role_type = 'Reviewer'
and review_id=:TargetObjectID
group by REVIEW_ID, COVERING_USER_ID
order by 3 desc
fetch first 10 rows only
) t1
Left join avuser.pv_users pU
on pU.id = t1.COVERING_USER_ID
)
Example of the results:
If you get an error at this stage, please test your SQL in a Query tool, like "SQL Developer" or "SQL Squirrel" to ensure it works first.
If it still doesn't work, please share your SQL and a screen shot of the issue below. DO NOT contact RSA Support
There are MANY other "display attributes" you can play with on this screen, so please update and make changes as you see fit.
Dont forget:
Please login, then "Like"
and "Actions/Follow" this page (Top Right), so as to receive updates and be notified if we modify/change items found here, in future.