Skip to main content
PradeepJaiswal
PradeepJaiswal
Level 3
July 4, 2017
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
    Adobe Employee
    July 5, 2017

    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 in thread

    8 replies

    Hyder_Ziaee
    Adobe Employee
    Hyder_ZiaeeAdobe EmployeeAccepted solution
    Adobe Employee
    July 5, 2017

    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
      scottt6073095
      Level 4
      July 6, 2017

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

      Translate
        Hyder_Ziaee
        Adobe Employee
        Hyder_ZiaeeAdobe Employee
        Adobe Employee
        July 6, 2017

        Will need to test that out. nice catch.

        Translate
        Hyder_Ziaee
        Adobe Employee
        Hyder_ZiaeeAdobe Employee
        Adobe Employee
        July 6, 2017

        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
        scottt6073095
        Level 4
        July 6, 2017

        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
        Adobe Employee
        Hyder_ZiaeeAdobe Employee
        Adobe Employee
        July 7, 2017

        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
          PradeepJaiswal
          PradeepJaiswalAuthor
          Level 3
          July 7, 2017

          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
          SM_AP1
          Level 2
          October 14, 2022

          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
            Terms & ConditionsAccessibility statement

            Loading footer...