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 ,

The most important as I read it is, that you need to have users mapped to specific region (As you need one indicator for all users, and one for users in specific region that have requested the catalog item. So, starting point, is the users map to a specific region according to your masterdata?

[Amy V2]

Hi Anders,

No, they are only mapped to a country. That's what prompted the question is how do I make the connection? The country on the user table for us is a 2-digit country code, which we can tie to our location table which does have the region field. Is there a way to do that within performance analytics or do I need to do a database view and is it possible to use a database view in performance analytics?

[jeffrubinoff]

I can't answer your larger issue but I can tell you that you can use a database view as an indicator source, as documented in https://www.servicenow.com/docs/bundle/yokohama-now-intelligence/page/use/performance-analytics/conc....