Change Adoption Report

[Community Alums]

Hello,
I need to create a report that displays how many groups have had a Change Request assigned to them.

We are trying to measure change adoption in the environment.

We need to see something that queries all of the active groups and shows how many of those groups have had a change request assigned AND those that have not.

I am thinking that a database view will get this, but I am not sure how to set this up.

Any assistance would be appreciated.

[AshishKM]

Hi @Community Alums, 

So you need two db view 1) for group used as assignment group on CHG and 2) group never assigned any CHG. 

Table : Group ( prefix : grp )

Table : Chang ( prefic : chg )

Condition : grp.sys_id = chg.assignment_group

Try with this setting and  share the screen shot if its not giving desire result. 

-Thanks,

AshishKM

-Thanks,

AshishKM

[Community Alums]

Hello,
Thanks for providing this info. We are looking to have this in one chart (pie chart probably) with 2 pieces where one is % of groups assigned to a change and the other is % of groups not assigned to a change.

Would the 2 db views work to obtain this result? If so, how do I obtain that?