Select specific User-Agents

Hello Team,

I have field “user agent” with different user-agents like

I have to add it as a “Filter”. It looks like that I should create a calc field for that?

Could you please help me to select only Iphone&Android devices?

Thank you.

Hi @weird_guy

You can create calculated field with IN function as follows

in(user_agent,[“iPhone”, “Andriod”])

The calculated field will return either a True/False value. You can filter your visual with this calculated field and select a value = 1 (for True)

More info on the IN function

Regards,
Giri

1 Like

@Giridhar.Prabhu Hello. Doesn’t work for my
Are you sure regarding expression “IPhone”, “Android” ?

image
image

Hi @weird_guy

Sorry! IN function looks for a complete match.

We should instead use the CONTAINS function

My test results

1 Like