Create filter list from multiple result rows

Hi,
I would like to create a list of values to use as a filter for another chart for example.
Query one result from custom query

fdst (example only)
15
23
39
40

Then I would like to use 15,23,39,40 as filtered in the other chart.
Currently Query one I have to use custom query as data is combined from 2 columns,
then use collect_list it shows like
image

When use this in filter like

source in (<< fdst >>)

it gives error Could not load data.
And from the profile log it shows like this
60,Parameters,0,“ffdst:{“key”:“ffdst”,“value”:”[“581”,“388”,“351”,“1584”,“459”,“1252”,“4681”,“1562”,“4030”,“736”,“1611”,“1820”,“4810”,“4029”,“860”,“642”,“780”,“4034”,“4033”,“1328”,“4028”,“583”,“579”,“6311”]",“filtername”:“ffdst”,“keytype”:1,“valuetype”:“STRING”,“source_visual_id”:3860,“source_dataset_id”:299,“source_shelf”:“dimensions_shelf”,“expr”:"[ffdst]",“scope”:{“filterName”:“ffdst”,“datasetId”:299}};fdst.ignore:{“key”:“fdst.ignore”,“value”:false}",

Is there a way we can use all rows result from custom query as a filter in another chart?
Please advise.
I appreciate much of your advise.

@Stima_Livingpresent just to clarify, you’re using a filter widget to select those first 4 values (15, 23, 39, 40), and then you want to click on your ffdst field in another visual and have that parameter pass in that list of values into another visual?