Filter and club dimension based on the value provided by user in 'contains' filter

[Anshu_Pathak]

Hi,

Is there a way to just show the value input by the user in the corresponding dimension and then generate results accordingly? For ex: in the image, the user filters by contains ‘44460654177-1’ and the output shows all the records which contains the text. I only want one single row with '‘44460654177-1’ and the sum of results in other columns. Is it possible to do that?

[thomas_brittain]

Hello @Anshu_Pathak,

Could you write a custom dimension, something like,

dimension: user_input {
    sql: "_filters['traffic_alloc.field_name']"
}

Then, the measures would group by whatever the user enters?

I’ve not tested it, but I think the theory is sound.

• Liquid Variables

Kind regards,
–Thomas