How to create report on inactive groups with active user(s) in Performance Analytics

[JinmokJ]

Hey everyone,

I'm fairly new to this feature and I am stuck on creating report using Performance Analytics as it does not have required options for me to pick in order to generate a report. 

For example, I need to know the number of numbers and group names for expired/inactive groups that are no longer in use with active users. 

Ultimately, I need to create a performance analytics indicator that measures the # of roles exclusively inherited by users who are members of inactive groups. 

Thank you team

[AndersBGS]

Hi @JinmokJ ,

Why Performance Analytics? In general I would recommend to create a report based on the sys_user_grmember with conditions for group is not active and user is active.

[Bhimashankar H]

Hi @JinmokJ ,

To create in PA, you need to create go to data visualizations then create new, there it will show all every time of reports to created like bar, pie, simple list, etc. once you select then you need to select the data source. In you case the table will 'sys_user_grmember' and condition will look like 'group.active=false^user.active=true'.  These configuration will have to do in configuration tab shown in below screenshot for report. Creating report in data visualization is like UI builder experience. 

For you second report " measures the # of roles exclusively inherited by users who are members of inactive groups." you need to create Indicator source -> Automated Indicators -> Indicator breakdown -> Data collection Job -> Formula indicator -> Indicator group with score/list view.

You need to follow these steps.

Thanks,
Bhimashankar H

-------------------------------------------------------------------------------------------------
If my response points you in the right directions, please consider marking it as 'Helpful' & 'Correct'. Thanks!

[JinmokJ]

Thanks for your reponse but I wanted to utilise Performance Analytics not Platform. Will keep informed though! 

[Bhimashankar H]

Hi @JinmokJ ,

So performance analytics is all about tracking key performance indicator over time to provide insights.  For this you need to create the indicators like source, group, automated indicators.

Performance Analytics is about measuring past performance and forecasting future trends.

I think I answered your query in past and this post as well.

Thanks,
Bhimashankar H

-------------------------------------------------------------------------------------------------
If my response points you in the right directions, please consider marking it as 'Helpful' & 'Correct'. Thanks!