Platform Analytics - Cascading Filters - Services + Offerings

[UC Paul]

Is it - possible to use Analytics Center Filters to follow filters from the same table (like items with a .parent relationship)?

I’m trying to build a dashboard with these filters cascading and I can’t get it to work.

I’m using two filters off of cmdb_ci_service.

The first filter is where class = Business Service

The second filter is where class = Service Offering

I’d expect to be able to link the filters so when the Service is selected, the Offering list is filtered to where cmdb_ci_service.parent = selected Service.

I’ve watched the academy on filters but I didn’t catch if we can or can’t use the same table? https://youtu.be/qEyh-lfvvok?t=2016

I’ve tried moving the Service Offering filter to service_offering table but I still don’t see the ability to follow other filters.

[Mark Manders]

What version is your instance on? Cascading filters will work properly on Xanadu. On previous versions there seem to be some issues with them.

[UC Paul]

Oh, that's good to know. Thank you.

[Vinod Ghadi]

Our instance is on Washington version & in the new Platform Analytics Experience, I managed to create cascading filter functionality using follow other filter option.

I wanted to use cascading for 3 different filters which uses data from same table "sys_user_group" where filters are separated with group type.

First filter created for Delivery Group where type contains "Delivery Group"
Second filter created for Service Delivery Group where type contains "Service Delivery Group"
& Third filter created for Assignment Group where type contains "ITIL"

for second filter I enabled option "Follow Delivery Group" from follow other filter option & similarly for third filter I enabled option "Follow Service Delivery Group" from follow other filter option.

cascading worked well but dashboard or data underneath doesn't show up on Delivery Group & Service Delivery Group selection even after mapping correct table in data to filter option.

It worked with separate selection of assignment group only but not with cascading

Anyone can help here?

[jeffrubinoff · Accepted solution]

A developer tells me:

"Yes, we for sure can cascade two filters on the same table. In the first filter's data to filter, just add the cmdb_ci_service table and parent field, it should work."