How do I filter by values in Workspace?

Question

Hey all,I'm trying to figure out how to filter out all rows with visits under 1,200. I work in news media and I'm only looking for stories that saw under 1,200 visits.I tried to create a segment to exclude values under 1,200, but the logic just doesn't work out.Is there any way I can filter by values?Thanks!

Balaji_V · Accepted Answer

Hi Andy,Can be done in Calculated metrics using logical functionThe result of the Calculated Metrics will list out the visits which have less than 1,200 visits.Thanks,Balaji

PratheepArunRaj · Answer

Dear Andy,Agree with Bala. Creating Visits > 1200 Segment with Hit or Visit container wont work because Hit is smaller container than Visit and Visit cannot be more than 1200 in a Visit i.e. Always 1. So it will work only for Visitor Container where there are less chances that a visitor would have more than 1200 visits in your selected period and tougher to apply it for dimensions.So you need to create a calculated metrics like above and use the calculated metrics against the dimension you need to apply. This will eliminate all the visits lesser than 1200 (Because Visits < 1200 will become 0). A trick to use!Thank You!Arun

Cadastre-se

Fazer o login com rede social

Bem-vindo

Fazer o login com rede social

Verificando arquivo em busca de vírus

Este arquivo não pode ser baixado