Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Adobe Analytics Coffee Break: On Monday, January 30 at 10am PT, the NOAM User Group led by Jennifer Dungan and Jeff Bloomer will be joining us to answer your Analytics related questions. To register and for more information, follow the link to the right.

Percentage Change Calculation with Limits

Avatar

Level 2

I know there is a way to calculate percentage change for a metric between two time periods (e.g. Page Views this month v. Last Month). The way that I do this is to use the "Compare Time Periods" option. However, if I break this down by Page, sometimes I see +1000% because some went from 1 page view to 10. I'm only interested in pages that had significant viewership (e.g. >100 page views). Is there a good way to layer this into the calculation?

1 Reply

Avatar

Community Advisor

One of the biggest drawbacks of Analysis Workspace is that you can't filter by metrics.

You also can't use segments. Although you can use metrics in segments, the metrics are computed as based on the data received per hit, not as an aggregate.

I think you'll have to run your report outside of Analysis Workspace, e.g. in Excel with Report Builder.