How to Obtain the Number of Computers Assigned Multiple Times to Users (Platform Analytics)

segarenc · ‎09-05-2025

I’m working on a dashboard where I need to create a Single Score widget that shows the percentage of laptops that have been assigned multiple times.

The formula is:

% of Laptops Assigned Multiple Times =
(Number of laptops where Assigned To has changed at least once) ÷ (Total number of laptops) × 100

To achieve this, I think ( not sure) that I need two automatic indicators:

1. Amount of computers that have been assigned multiple times (this is where I’m stuck).

2. Total number of laptops (this one is straightforward).

My idea is to then create a formula indicator that calculates the percentage.

My Questions:

1. How can I create the automatic indicator for computers assigned multiple times?

- From my research, it looks like I may need to create a scripted automatic indicator, but I’m not sure how to add the script into the automatic indicator definition. I already wrote some script logic (screenshot attached), but I don’t know how to plug it in.

2. Is there another easier solution for this use case instead of a scripted indicator?

Any guidance or examples would be really helpful.

Thanks in advance!

Bhuvan · ‎09-05-2025

@segarenc

Logic should be fairly simple and can be reused from incident formula indicator '% of open incidents reassigned at least once'

Create a field that would track computers that are assigned multiple times similar to incident reassignment counter. Check business rule on task table for reference,

Create an automated indicator to track total number of computers and another indicator for tracking computers whose assignment counter is > zero. Create a formula indicator to calculate % of computers assigned multiple times. Below is similar reference from incident table formula indicator,

Add the indicator to dashboard and share it with users/groups.

If this helped to guide you or answer your query, please mark it helpful & accept the solution.

Thanks,

Bhuvan

View solution in original post

Bhuvan · ‎09-08-2025

@segarenc

Thanks for marking the post as helpful.

If my response helped to guide you or answer your query, please accept the solution.

Thanks,

Bhuvan

segarenc · ‎09-08-2025

Hi @Bhuvan ,
Can you please provide me with the steps on how to solve these two issues:

1. Since I’ve only just set this up, only new changes are now being stored in the metric table. What about the old data, where laptops had their Assigned to field changed several times in the past? How should I handle that?

2. I also need to construct an automatic indicator (with a script), where the indicator source is the metric. Could you please help me with the script that should be included in the automatic indicator?

Thanks in advance!