How to filter on column type ARRAY


is there a way to filter on column type ARRAY? I would like to filter dashboard only for rows where array contains a specified value

Best regards

1 Like

Thanks for the suggestion, @jurajkapasny!
We haven’t supported filtering on array columns just yet. That said, there are some workarounds for your case:
1/ Convert the array to string, and then use the contains filter.
2/ Unnest the array into a separate model, then join it back to the original model, and filter on the unnested column (You can refer to our doc for more details: Handling nested JSON | Holistics Docs)

I hope this is helpful! In the meantime, I’ll note down your case for future improvements on filters. Cheers! :raised_hands:t2:

Thank you. the second option worked great!

1 Like