Allow Filtering report columns/metrics for Limits & Ranges | Community
Skip to main content
M
mcolema1
Level 5
June 18, 2012
Investigating

Allow Filtering report columns/metrics for Limits & Ranges

  • June 18, 2012
  • 12 replies
  • 17512 views

To allow more effective analysis, reporting and dashboarding, allow us to filter report columns/metrics by settng value limits or ranges. 

 

Example: Looking at Bounce Rate on Entry Pages with Visits also as a metric, let us set the limit on the Visits column to > 1000 - so we don't see all the very low volume and low frequency pages and instead see the most valuable items to focus on.

 

Should allow Less Than, Greater Than, Equal, and Ranges on any column in a report.

    12 replies

    Show previous replies
    I
    Adobe Employee
    ivan-andresAdobe Employee
    Adobe Employee
    April 10, 2018

    I know it's not the same as filtering, but you can create a calculated metric like "if ( visits > 1000, bouncerate, 0 )".  Then anything with less than a thousand visits will be sorted to the end (if you're looking for high bounce rate).  You can change the 0 to a large number (say 1000) if you want to look at low bouncerates.  Or you could be even more sophisticated and interpolate between the total bouncerate (i.e. the bouncerate for the site overall) and the page's bouncerate if visits < 1000.  That way there wouldn't be a hard cut off at 1000 visits.

    Andrew_Wathen_
    Community Advisor
    Andrew_Wathen_Community Advisor
    Community Advisor
    April 10, 2018

    Yes, this does theoretically achieve the same result, but from my point of view this is impractical as it requires the creation of a new calculated metric every time you want to do this.

    Terms & ConditionsAccessibility statement

    Loading footer...