Right now the only filter option for text that accepts a parameter is the custom filter, which allows for equal and does not equal inputs. Is there anyway I can pass multiple values to a parameter like the above URL?
For more details I have many options ~500 million, which will be a pretty poor user experience if users need to filter on the dashboard for these. So instead I have a search engine through AWS Cloudsearch and a basic js search widget that quickly filters through the values as the user types within my web app. I want to pass the user selections to update the URL of an iframe that displays the dashboard in my web app.
Could you provide screenshots rather than the links to the parameters that you are referencing? The links require a log in I’m assuming to your Quicksight environment.
For the values that you want to associate to the parameter, do you mean that you want to attach multiple fields to the parameter for your filter?
@duncan Hi Duncan, No instead of applying multiple fields to the parameter I want to be able to input multiple values to the parameter, all of which would be filtering the same column.
The links above were just dummy links for purpose of example. Within my dataset I have a column called metric, for this column I have a parameter also called metric… but lets say its called paramMetric as that’s easier. From the modal where I create parameters I’ve selected Multiple Values for my above paramMetric parameter. I was hoping that I could pass multiple values to this parameter through the URL.
Right now the only parameter filter you can apply on a text column (my column metric is text) is the Custom filter, which I’m using. Custom filtering only allows for equal or does not equal filter conditions when using parameters, I’m using equal. I was hoping I could pass multiple values to this custom filter as my parameter is Multiple values. However it appears that’s not the case, which kinda makes sense as I’m using the equals filter condition, but also doesn’t make sense as I’ve selected Multiple values for that parameter.
I think right now what I’m looking for is a feature-request to add contains to the custom filter with parameters or to allow the filter type of custom filter list to be useable with parameters. I’m pretty much trying to treat the above like a custom filter list, which allows you to pass values followed by a separator as filter options. For my use case though I have far too many filter options and would just like to be able to pass these separated values to the URL and filter that way.
@duncan Yes that does work, any of the multi selects will get the job done. However it would be an extremely large filter with 10’s of millions of options. Which makes this a really weird niche case, some of the options aren’t easily predictable and/or have many very similar text. Which makes it very hard for me to filter using any of QS built in filters.
My use case is really trying to show Quicksight shine at embeddable analytics which is why I’m trying to get as much use out of parameters as possible and opting to build a search engine on top of this large number of options.
I think my best option going forward is to just create 10 different incremented parameters with different OR arguments filtering my data.
