Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
This worked! Thank you!