Filtering values (higher or lower than threshold)

Question

Hi there,

I have a freeform table with unique visitor as a metric and dimension (evar) as a row, I'd like to exclude all rows with UVs <5000. when I try to build that segment through the filter configuration located at the top of the panel, "unique visitor" is not an available option in metric list, and when I selected "visits" as an alternative (due to it's similarity) and build a filter out of it, the table does not return any results. how can I fix this?

Jennifer_Dungan · Accepted Answer

You can't really do this...

Someone had an almost identical question the other day: https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-questions/segment-to-display-only-pages-with-more-than-100-pageviews/m-p/613543

Basically, the best I could do was suggest creating a calculated metric using the IF function in conjunction with the Less Than and Equal To / Greater Than and Equal To functions.

The rows will still show, but anything outside of your threshold will show 0 instead of the metric value.

Segments are Hit, Visit or Visitor based, (i.e. Hits that are X, Visits that contain Y OR a an individual user that has done something Z) so you cannot segment by pages that have X Visitors... it's just not how segment were designed to work.

MoriE2 · Answer

Thanks, this is a half-way solution though, because it does not filter out the rows. It is quite surprising that how such a basic filtering rule is not available/applicable as a built-in function in Adobe!!

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded