How to display only those record(say page url) in table which have visit count greater than x(say 1000) | Community
Skip to main content
PradeepJaiswal
PradeepJaiswal
Level 3
Jul 4, 2017 4:16 PM UTC
Solved

How to display only those record(say page url) in table which have visit count greater than x(say 1000)

I have a table(page url and visit count) in worspace. how to display only those page url which have visit count more than 10k ?

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Hyder_Ziaee
    Hyder_ZiaeeAccepted solution
    Employee
    Jul 5, 2017 1:44 PM UTC

    Here is how you can do it...

    (I have done it with Page, and Visits >= 3000)

    Create a calculated metric:

    This is how it shows up:

    View reply

    8 replies

    SM_AP1
    Level 2
    Oct 14, 2022 1:53 PM UTC

    Adobe Insight (the old Visual Sciences - not sure what it is called now) had the option to limit the data shown by pretty much any metric in the table - would be nice to have that feature in AA - without having to create custom Metrics.

     

    Just a thought

     

    Thx

    SM_AP1

    Translate
      PradeepJaiswal
      PradeepJaiswalAuthor
      Level 3
      Jul 7, 2017 5:04 PM UTC

      Exactly was my question "how to display only those page url which have visit count more than 10k ?" , I wanted to get ride of that row record it self from the table after using calculated function metric.

      Translate
      Hyder_Ziaee
      Hyder_Ziaee
      Employee
      Jul 7, 2017 5:55 AM UTC

      Yeah...that's an unfortunate thing. I wasn't able to remove them.I tried the using segments within the value_if_false part to remove the pages, but didn't work. The best that can be done is to use the setting to show zeroes as blanks.

      Would help if there was a setting for not showing dimension values where the result is zero.

      Translate
        scottt6073095
        Level 4
        Jul 6, 2017 11:03 PM UTC

        ok, the total makes sense since its above 3000 then it will show however anyway to get rid of zero records? I would only want to see records if they are 3000 or greater

        Translate
        Hyder_Ziaee
        Hyder_Ziaee
        Employee
        Jul 6, 2017 5:48 PM UTC

        thinking about this...the formula is to show the number if it is greater than 3000.

        Since the total is greater than 3000, it is showing up.

        Translate
        Hyder_Ziaee
        Hyder_Ziaee
        Employee
        Jul 6, 2017 5:44 PM UTC

        Will need to test that out. nice catch.

        Translate
        scottt6073095
        Level 4
        Jul 6, 2017 5:34 PM UTC

        Is there a way for the total to match the visits >= 3000 and to remove the 0 records from the table?

        Translate
          Hyder_Ziaee
          Hyder_ZiaeeAccepted solution
          Employee
          Jul 5, 2017 1:44 PM UTC

          Here is how you can do it...

          (I have done it with Page, and Visits >= 3000)

          Create a calculated metric:

          This is how it shows up:

          Translate
            Terms & ConditionsAccessibility statement

            Loading footer...