I have set up click behavior functionality to navigate to a specific destination URL when clicking on a question. It works fine when passing a single variable with one value, but it fails when passing multiple values, as they are being sent as comma-separated values in the URL.
Exact Issue:
Metabase treats parameters with multiple values as a comma-separated list (a,b). However, to correctly pass multiple parameter values for a public question page, it requires a different format:
?param=a¶m=b
This prevents ambiguity between a single string value ("a,b") and two separate values ("a" and "b").
How can I modify the click behavior URL so that multiple values are passed as separate parameters (?param=a¶m=b) instead of a comma-separated list (?param=a,b)? Is there a workaround to achieve this in Metabase ?
Any suggestions or solutions would be greatly appreciated!