How do I add an OR condition to interactive filters within a Platform Analytics dashboard

matthew_hughes
Kilo Sage

Hi everyone,

I've setup some interactive filters based on the Department table that are dependent on each other, and it filters the data within the data visualisations e.g. the correct number applies at 'Tier 3 Organisation' filter:

matthew_hughes_3-1743429334840.png

 

 

However, what I've noticed is that if apply a filter on the child filter 'Tier 4 Organisation', no results show:

matthew_hughes_6-1743429472402.png

When I click into one of the reports, it's not including an OR statement for the different entries:

matthew_hughes_8-1743429645219.png

 

 

I can only get the correct results to appear from the 'Tier 4 Organisation' filter by clearing out the value of the parent filter 'Tier 3 Organisation':

matthew_hughes_5-1743429417627.png

I'm currently applying the following sets of filters for each interactive filter:

matthew_hughes_7-1743429522328.png

 

I was just wondering if anyone has seen this issue before and what I need to do to fix it.

5 REPLIES 5

Bert_c1
Kilo Patron

See: Filters in Platform Analytics

includes a video

Hi @Bert_c1 I had a look at that video, but it didn't explain how to fix my issue

post some feedback on that page. Create a Support Case (however the response may be 'working-as-designed'). Wait for suggestions by others here.

@Bert_c1 So do you mean create a HI Ticket?