Percentage Change Calculation with Limits | Community
Skip to main content
C
czmudzin
Level 3
January 10, 2023
Solved

Percentage Change Calculation with Limits

  • January 10, 2023
  • 1 reply
  • 984 views

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?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by yuhuisg

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.

1 reply

yuhuisg
Community Advisor
yuhuisgCommunity AdvisorAccepted solution
Community Advisor
January 11, 2023

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.

Terms & ConditionsAccessibility statement

Loading footer...