Filtering on arrays

[jenniferboughton]

Hi all,

I'm trying to create a filter for what was originally an array in my dataset: 

issue_number	areas	severity	areas_string
3344	[ "App" ]	1	App
3345	[ "App", "Website" ]	1	App,Website
3346	[ "Website" ]	2	Website
3347	[ "Website" ]	1	Website

I'd like to create a filter (for either areas or areas_string) that when I choose "App" would return issues 3344 and 3345 and when I choose "Website" would return issues 3345, 3346, and 3347. 

How can this be done?

Thanks!

[marcus_sommer]

You may try the following:

load issue_number, subfield(areas_string, ',') as areas_items from source;

to create an extra dimension-table with issue_number as key and areas_items is then your selection-field.

- Marcus

[jenniferboughton]

This worked! Thank you!