Applied filter on platform analytics not working

[s_renjarnbo]

I have created a dashboard in Platform Analytics. I have 2 visualizations based on data in a custom table. The table has a "Requested for" field which pulls data from the sys_user table.

I have created a multiple select filter on the dashboard based on the "requested_for.location":

I data in the filter is correct and I can select data in the filter drop down:

but when I click "Apply" the column "To be applied" is cleared out and no filters are applied to my data.

By the way - we are on Yokohama

[abirakundu23]

Hi @s_renjarnbo,
Check that the filter is correctly mapped to the data source/visualizations under "Filter Condition.
Test using a single-select filter or redesign the filter to target a simpler field (like user directly) to test if it’s a structural issue.

Please mark helpful and correct answer if it's worthy for you.

[s_renjarnbo]

Hi abirakundu

Thanks for helping out.

So in the custom table I have records with a reference field to sys_user table. I wanted to be able to filter the records based on the "Requested for" users locations and hence I set it up as displayed in my original post.

My data visualisations are both linked to the custom record table and are of type "single score".

Changing to a "single-select" does not help. The selection is automatically deseleted when I click "Apply"

I have also tried to add a new filter to use the "user" directly, see below:

That does not work either.....

I have also tried to set up the filter on a "List" but there I cannot find the "follow filter" option at all.

Please help..... 

My idea was to set up a filter 

..... Just as an afterthought - I have tried adding "default values" in my filters one by one to test if there is some kind of connection AND the filter with a default values works as intended.... so there is a binding !!!!

[s_renjarnbo · Accepted solution]

Funny thing......

I have re-created my dashboard using "In-line editor" option instead of "Technical editor" option and here everything is working as expected..... 

Strange

[jeffrubinoff]

Not strange, and if you had mentioned that you were trying to create a filter in a technical dashboard, we would immediately have asked you how confident you were in the custom event handler you wrote for the filter,  as documented in https://developer.servicenow.com/dev.do#!/reference/next-experience/yokohama/now-components/sn-compo... and as referenced in https://www.servicenow.com/docs/bundle/yokohama-now-intelligence/page/use/par-for-workspace/task/add....

In-line dashboards have more preconfiguration done than technical dashboards, and it is not necessary to create event handlers for filters on an in-line dashboard.