Dashboard Variable - Key Value Not mapping

I am trying to map the key and value from an value return by the big query data source
so, The regex used is this

But instead of getting all the row value i am getting only the first row

and then modified to
image

Got all the rows but in the dashboard when i try to get the text or value(combine)
platinum_clean is the variable name

for example
${platinum_clean:text}
it returns the text text correctly
when given ${platinum_clean:value} returns value correctly
we have merged the two columns and from the big query we’ll get
like this
12345 - RM | Dashboard in Progress
67890 - GH | Dashboard in Progress
but this returns only one row, but i have many rows, 1. Is there a way can i return all the rows with kay value

and others are not correctly mapping in this below regex
image

also i am using this variable in query as well, 2. so is there any way i can use both percentcode and :value

image

1 Like

Hello @bs43 are you using postgresql ?? please share your panel screen short for more clerification.