Multi-value filtering of dataset2 from parameter filled in by dataset1

Q&A
, , ,
1

I continue to struggle finding another question that meets my need, or for understanding the many responses that are similar. Seems there just aren’t any “cook-book” styled documentation or responses that help illustrate how this is supposed to work.
I have dataset1 with App-ID and Host-ID values
I have dataset2 with Host-ID and a lot of fields that describe that host (name, FQDN, OS, IP, etc.)
I created a parameter for the Host-ID as multiple value, integer, no default
I have a visual for dataset1 that shows both IDs - with a filter/control on App-ID (if I select a value here, I expect the parameter to be loaded with all the appropriate Host_IDs for the given App-ID)
I have a Host-ID control that shows the relevant list of Host-IDs for the selected App-ID

I have a second visual of the Hosts, and I want that visual to be filtered for all the Host-IDs in the parameter multi-value list based on the filter setting of the App-IDs … I added a filter, cross-sheet, cross-dataset, custom, using the parameter.

I get no filtering of the second visual if I leave “All” host id values selected in my parameter list/control - but if I leave only one Host-ID selected in the multi-list control, my visual is in fact filtered.

How is it, exactly, that I need to go through the process of using the first dataset, filter for a value, load a parameter with multiple values, then have that filter the second dataset based on the same field (Host-ID) in both datasets?

Thanks, in advance for anybody that can clear it up without just pointing me to the documentation chapters that do not explain it clearly.

2

Hi @jnkline – You can filter across two data sets if you are using a field that has the same name and same data type in both the datasets. In your case, i assume that will be “Host-ID”. Since “App-ID” does not exist in the second dataset, you won’t be able to filter using that field.

Please see this post where this is explained with screenshots.

1 Like
3

Thank you @awsvig, but this is not “exactly the same” thing here, I believe.
The referenced post clearly is filtering on only the same/shared field name.

I first need to filter on the App-ID in order to get the list of Host-IDs that are then common. How do I filter dataset 1 on App-ID and pass the list of Host-IDs on to filter dataset 2? Without forcing the table join of the one to many relationship and expanding the dataset to hundreds of thousands or even millions of records to then do what is shown in that post.

1 Like
4

Hi @jnkline – I believe, this is not possible for now. If all of your filters are for 1 dataset, then you can configure them to change based on the selected value of the 1 or many filters. Please refer this post..
At AWS, our roadmap is primarily driven by our customers. Your feedback helps us build a better service. I have tagged this as a feature request.

1 Like