Performance Analytics - % out of Total as Bar Chart by Breakdown

[Amy V2]

I am new to Performance Analytics and struggle with creating new reports from scratch. We use Legal Service Delivery and have the Performance Analytics Content Pack for Legal Service Delivery. I am looking to create a performance analytics widget that shows the # of unique users who submitted a specific catalog item in 2025 against the # of currently active users for a specific geographical area, essentially a percentage of users in that region who have submitted out of the total users in that region. Ideally it would be a single widget and look like a horizontal bar chart showing each region and what % complete it was, similar to how the % complete field works on tasks.

How would I go about doing this, if it's even possible?

[AndersBGS]

Hi @Amy V2 

You could create an automated indicator that count the district based on requester for the specific item, and an automated indicator to capture the amount of users. This should give you the baseline for the formula indicator to create the percentage. 

[Amy V2]

Hi Anders,

I was able to figure that much out and can create a Score/Dial widget with the formula indicator, but I'd have to do one for each region. I'd prefer if I could do it all in one bar chart, if possible. It may not be possible but it doesn't hurt to ask!

Something that would look similar to below. I know that's from a % complete field, but the graphical representation and one line per region is what I'm after.

[AndersBGS]

Hi @Amy V2 

have you tired a breakdown widget and break it down by region? I think that this would be the only solution,

[Amy V2]

Hi Anders,

Thanks for your prompt response again! I have not tried one. I thought that may be the answer but I admit I'm stumped on how to achieve it. Our user table does not have a field for region, so I can only rely on the country field. On our submitted requests, we used the Requested For's country to assign a region using a client script. This comes from our location table where we added custom fields to hold a region. Do you have some basic steps I can start with to try to get the information into a breakdown widget? Any help is appreciated!