Interactive filter - Filtering total incidents by company name in core_company table

[HasarinFareeth]

Hi - I wanted to create an interactive filter where I can filter the total number of incident created and closed by each supplier. The supplier data is available in company table (core_company) and I know I need to create a reference type filter which is not working for me. Can anyone guide me how to achieve this, please? 

[Mark Manders]

Then you need to dotwalk through the assigned to-field to the company field on the user table.

[Voona Rohila]

Hi @HasarinFareeth 

Can you please share the interactive filter you created?

Did you add the interactive filter reference?

The above setup will apply the filter on your report for the reference fields you define here.

Adding link for reference : Create a reference field interactive filter

[HasarinFareeth]

Thank you for the response. Here is my interactive filter, 

Interactive Filter references:

Unfortunately, there is no direct relationship between incident table and company table in our instance of service now. We will have to go through assigned to -> User table -> Company. The Company field in the incident table is set as blank in our system. 

Thanks

Fareeth

[Voona Rohila]

Hi  @HasarinFareeth 

You can dot-walk to the Assigned to company field.