How do I filter by values in Workspace? | Community
Skip to main content
A
andyb29407885
Level 2
July 2, 2019
Solved

How do I filter by values in Workspace?

  • July 2, 2019
  • 4 replies
  • 2896 views

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!

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Best answer by Balaji_V

    Hi Andy,

    Can be done in Calculated metrics using logical function

    The result of the Calculated Metrics will list out the visits which have less than 1,200 visits.

    Thanks,

    Balaji

    4 replies

    Balaji_V
    Balaji_VAccepted solution
    Level 4
    July 3, 2019

    Hi Andy,

    Can be done in Calculated metrics using logical function

    The result of the Calculated Metrics will list out the visits which have less than 1,200 visits.

    Thanks,

    Balaji

      PratheepArunRaj
      Community Advisor and Adobe Champion
      PratheepArunRajCommunity Advisor and Adobe Champion
      Community Advisor and Adobe Champion
      July 4, 2019

      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

      Thank You, Pratheep Arun Raj B (Arun) | Xerago | Terryn Winter Analytics
        A
        andyb29407885Author
        Level 2
        July 15, 2019

        Brilliant! Thanks so much, Balaji!

        A
        andyb29407885Author
        Level 2
        July 29, 2019

        Hey Balaji,

        Wondering if you can help me develop this calculated metric even further - I'm trying to figure out how to filter out all rows with visits under 1,200 AND visits above 300 visits. I'm trying to write a nested if/then with both functions, but just can't figure it out.

        Thanks!

        Terms & ConditionsAccessibility statement

        Loading footer...