How to configure cascading filters in Platform Analytics Dashboard based on reference field values?

[Sathwik1]

Hello Team,

I'm working on a Platform Analytics dashboard in ServiceNow Australia (Patch 7). All reports on the dashboard use the kb_knowledge table.

I have configured two dashboard filters:

Category — Reference field to kb_category

Service Offering — Reference field to service_offering

Requirement:

When a user selects a Category, the Service Offering filter should dynamically display only the offerings associated with that selected Category. The relationship between Category and Service Offering is available through records in kb_knowledge, where both reference fields exist.

What I've tried:

Configured both filters using their respective reference tables.

Configured the Data to filter settings for both filters.

Enabled Follow other filters on the Service Offering filter, but the Category filter is not available to follow. The configuration shows that the filters cannot be followed.

Checked the Many to Many Definition (sys_m2m) table but couldn't find a matching relationship between kb_category and service_offering.

Questions:

Is it possible to achieve this requirement using native cascading filters in a standard Platform Analytics dashboard?

Can a Database View joining kb_knowledge, kb_category, and service_offering enable this cascading behavior?

Is there any supported way to dynamically populate the Service Offering filter based on the selected Category, possibly using a Script Include, without using UI Builder or creating a custom physical table?

I'm looking for a supported solution that works with a standard Platform Analytics dashboard.

@Ankur Bawiskar @Tanushree Maiti