Need to create a report from a custom field

[Scott_ John]

I need to be able to track which of our customers are impacted by a particular incident, then create a report with that information.

Example - Customer ABC has submitted 5 tickets in Feb 2026

I was thinking of using a test field to report on this.  Dropdown may be difficult to maintain as new customers are onboarded.

[Marc -Devoteam- · Accepted solution]

Hi @Scott_ John 

Welcome to the community.

Best solution that I can provide you is to start using Assets, as you seem to be on a premium subscription.

Add your customers as objects in Assets, then create a custom field of type assets, where you could a multiple customers as options.

Of course you could do this with a multi-select field as well, but if Assets are used on a work item, the work item is auto related to the asset.

So from the custom asset, you could also see which issues would have had an impact on this customer.

[Scott_ John]

thank you for your input.  My only concern is that we have hundreds of customers, it may be difficult to maintain that list in Assets.

This other question I have is this resolution seems to imply I am looking for how many times a specific customer was impacted.  I am looking for a way to get total number of customers impacted and then report out on that:

Customer A reported 6 issues 

Customer B reported 10 issues 

etc....

[Marc -Devoteam-]

Hi @Scott_ John 

Do you want this per customer or per customer company?

Per customer, create a dashboard and use a 2 dimensional gadget and get all issues in your project and user the fields reporter and issue as fields.

Btw, on you space on selecting the customers option you can see how many issues a customer has open or have been closed 

You can do this if per company:

1. You use organizations on your JSM project and customers raising issues are linked to an organization
2. Use Assets
3. Use a custom field with customers as options of the field.

[Scott_ John]

@Marc -Devoteam-  This is great thank you!

[Marc -Devoteam-]

Hi @Scott_ John 

Please accept my answer as a solution, if my answer helped to solve or provide a workaround to your request.

This will help other community member trying to solve the same or provide them with a work around

P.S. If the answer is very valuable to you, please share some kudos.