Report to show users with more than one computer

Paulo Andrielli
Tera Expert

Hi all,

 

I am trying to find a way to make a report that shows the users that has more than one "computer", based on the "Assigned to" field.

I can group by this field, but I also see the ones that has a single one, and when I try to transform in a visual chart, the sum will be all compĂșters I have, not only the ones that has more than one assigned.

 

Is there a way to make a filter in the report to show only the users that has at least 2 or more assets assigned?

1 REPLY 1

Shivalika
Mega Sage

Hello @Paulo Andrielli 

 

No this is not possible by standard reporting. But you can definitely create a custom filter by GlideAggegate API. Then use this filter to put condition on count. 

 

Additionally you can use Performance Analytics which will easily solve your work. 

 

Kindly mark my answer as helpful and accept solution if it helped you in anyway,

 

Regards,

Shivalika 

 

My LinkedIn - https://www.linkedin.com/in/shivalika-gupta-540346194

 

My youtube - https://youtube.com/playlist?list=PLsHuNzTdkE5Cn4PyS7HdV0Vg8JsfdgQlA&si=0WynLcOwN

eEISQCY