I want to add an Einstein Analytics dashboard to a custom object which field values do a certain filtering on the data of the dashbord.
The problem I face is that one of the fields is a multiselect picklist which doesn't work with the contains operation of the dashboard filter.
I need something like a has-any
operator to use data rows that match with at least one value of the picklist.
This is how my Lightning filter statement looks
{
'datasets':{
'getSource':[
{
'fields':[
'Product__c.Brand__c'
],
'filter':{
'operator':'matches',
'values':[
'$AllowedBrands__c'
]
}
}
]
}
}
Here is also a video demoing the problem contributed by Peter Lyons: https://youtu.be/pJLoua8nOqw
Or am I running into this documented limitation? If so, when and how will this be fixed?
ADDED LATER:
Just stumbled over a video from TrailheadX where they show how to apply filters using the Analytics Web SDK and they use an IN Filter
Best Answer
This was a bug which has been patched. Multiselects are now supported in embedded filters without hacky workarounds.