Expand my Community achievements bar.

Join us at Adobe Summit 2024 for the Coffee Break Q&A Live series, a unique opportunity to network with and learn from expert users, the Adobe product team, and Adobe partners in a small group, 30 minute AMA conversations.

Allow Filtering report columns/metrics for Limits & Ranges

Avatar

Level 10

6/18/12

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 Comments

Avatar

Employee

4/10/18

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.

Avatar

Community Advisor

4/10/18

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.