I am attempting to build a calculated metric to provide the average (mean) number of page views over a time period. Tried using the Mean function which seems to work in preview but is incorrect in a Metrics reportlet. Here is my calculation:
List Builder Segment (Mean ( metric Page View Summary include zeros true) ) )
Additional attempts to construct a metric and use it as a denominator have also failed.
Again, in the preview panel it seems to count the number of days or calculate an appropriate result but whne the metric is inserted in the Site Metrics Reportlet the results is not calculated as expected.
So the first step would be to get the calculated metric
Once done you can get the values in two ways in Analysis Workspace:
1. Months broken down by Days
Here the months will show the average visits across all months (example: 90388). However, the day breakdown will show the average daily visits across each month (example: 3026, 3052, 2975 and 3004). I have collapsed all days to have just the average daily number shown
2. Cross-tab between months and days
I have got the days as a dimension column in the table. The months are under the average visits metric as column each. Again, I have the day metric collapsed, so that only the concerned number is seen.
I understand, both these methods are not very refined, but they are easy to create. If want to have refined and a solution that you do not have to tweak continuously, I would recommend Report Builder.
I have the same question but see that there is no response posted here. Do you happen to know if there is a way to do this? I'm trying to create similar time-based averages for Pageviews in Workspace. Thanks!
I would like to have some more information on the type of metric you want to create. Will it be a daily average page views or a average total page views or average page views per visit? All of them would require a different approach.