Ability to add a comma separated list of entries in a dashboard filter

[ccoelho]

Hi,

Currently in the filters, we are unable to directly filter a comma separated list of entries. The options available are individually selecting the members, however that can get tedious if the list of entries we need to filter are large. For example, filter more than 100 entries.

The other option is using the custom option in the filter. However, that too requires JAQL code which might be difficult for non technical users. 

It can be useful to have the option to directly copy paste a comma separated list of entries in the filters instead of multiselecting or using the custom JAQL option.

[DRay]

Hello @ccoelho,

Thank you for your Idea. We appreciate you being an active member of the Community!

I would be happy to bring this to the Product team, but first I would like to get some more information and head off any roadblocks to implementation.

1. Sisense filters only display values that are actively present in the visualization. How should Sisense handle it if there are values in the .csv that are not present in the Widget or Dashboard?
2. How often do you think this functionality would be needed? If it's infrequent it might be easier to create a separate Widget for the individuals that need that much filtering. That way they can just use that widget rather than messing with the filters each time.
3. There a several Plugins that offer enhanced Filters. Have you looked at any of them? If so, do any of them provide a similar experience to what you are looking for that we can use as a reference?

Thank you for working with me to get this Idea fleshed out so it can be evaluated and scoped for effort.

Have a great day!

[dougnewton]

I think he is suggesting not that we upload a CSV, but rather just enable pasting in a list of entries into the 2nd radio button option, and then it could mass-select what you pasted. 

[DRay]

Hi @dougnewton.

Thank you for your participation! I am still not sure how we should handle instances where values in the pasted content don't match the values available in the visualization.

One current work-around would be to export the Widget as a .CSV, and then filter that in the spreadsheet software of choice. 

[dougnewton]

Maybe just ignore it.  So if my list of available values are integers 1-10, and I paste in a string that looks like:

   1, 5, 8, 24, 31

It would just ignore the 24 and 31, because there's nothing there to select that matches.

[ccoelho]

Hi DRay

Please find below my answers to the questions:

1. Sisense filters only display values that are actively present in the visualization. How should Sisense handle it if there are values in the .csv that are not present in the Widget or Dashboard?

The idea is to allow passing in any value through a text box. Currently, the custom script option allows that, so the value that is passed, would be used in the SQL layer as an IN clause to filter the results. If the value is not present in the table or widget, it will not return any row for that value. 

1. How often do you think this functionality would be needed? If it's infrequent it might be easier to create a separate Widget for the individuals that need that much filtering. That way they can just use that widget rather than messing with the filters each time.

Currently we use this for table widgets, but the ask is to allow the capability through a filter, so it can be applied to any widget. So even if there are lets say 10 values to filter, rather than individually selecting the 10 values , having an option to export that 10 values as a list will be easier.

1. There a several Plugins that offer enhanced Filters. Have you looked at any of them? If so, do any of them provide a similar experience to what you are looking for that we can use as a reference?

I have not come across anything similar which is unpaid. Could you guide me to any plugin available?

[DRay]

Hi @ccoelho,

I'm not aware of a free plugin.