Exclude Specific Browsers From Query Results

[cwinkler109]

We use the following query in Data Explorer to monitor LCP:

builtin:apps.web.action.largestContentfulPaint.load.userType.geo:filter(and(or(in("dt.entity.application_method",entitySelector("type(application_method),entityName.equals(~"loading of pdp~")"))))):splitBy("dt.entity.application_method"):percentile(95.0):sort(value(percentile(95.0),descending)):limit(20)

Is it possible to modify that query to exclude LCP data from the "FacebookBot" browser?

[AntonPineiro]

Hi,

I would say no, as you can see, browser is not a metric dimension:

Best regards

[cwinkler109]

Yes, for me Browsers is a dimension:

[AntonPineiro]

Hi,

Yes, I was checking another metric. Which options appears to you in filter field?

Is not there?

Best regards

[cwinkler109]

Yes, I can filter by browser. Many different types of browsers are available for me to filter the results by. 

My question is how can I exclude one of those browsers from the results. For example, how would I write my query to retieve and trend LCP metrics for everything EXCEPT the "facebookbot" browser.

[AntonPineiro]

Hi,

I see your point. @mark_bley has already pointing you in the right direction. You need to use "not" to exclude it.

Best regards

[mark_bley · Accepted solution]

You will need to adapt the query and negate the browsers you are not interested in, here an example:

builtin:apps.web.action.largestContentfulPaint.load.browser
:filter(
    and(not(in("dt.entity.browser",entitySelector("type(browser),entityName.in(~"Chrome 100~",~"Chrome 101~",~"Chrome~")")))
)
)
:splitBy("dt.entity.browser"):sort(value(auto,descending)):limit(20)

[cwinkler109]

Perfect. Thank you!