kalnyc67 / analytics-issues

Automatically exported from code.google.com/p/analytics-issues
0 stars 0 forks source link

Custom reports : Sum of the values displayed in the graph doesn't match the total #567

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago
---------------------------------------------------------------------------
NOTE: This issue tracking system is for Google Analytics developer products
only.
If you are not a developer/programmer visit:
http://www.google.com/analytics/support.html
---------------------------------------------------------------------------
Name of affected component: Core Reporting API

Name of related library and version, if applicable (e.g. Java, Python,
HTTP, Objective-C, etc.): Java

Issue summary:
We are using analytics reporting API to retrieve the data for different metrics 
and dimensions. We then verify the data against analytics reports/graphs. 
The instance in which we are facing the issue is, we are fetching the data for 
ga:users metric with ga:source dimension. i.e. we are fetching the data for 
users with different sources. We store day by day data and calculate the 
aggregate for the whole month.
We then compare that aggregate (sum) for different sources with google report 
(via custom reports) but the values don't match. We tried comparing day by day 
data for particular source (e.g. google) and it matched. However, the aggregate 
values are different.

On further investigation, we found that the values displayed below the 
reporting graph (on analytics page) don't match the sum of all the values. E.g. 
If we query the data for December 1st to 10th, 10 points are displayed in the 
line graph and a value (presumably the sum) gets displayed below the graph. 
When we add all those 10 values, the number is different (and in most of the 
cases, greater) than the number displayed below graph.

Steps to reproduce issue:
1. Go to 'Customisation', click on 'New Report'.
2. Select 'Users' as metric, 'Source' as dimension and 'google' as filter. 
Select the date range from 1st December to 31st December (or any range).
3. A graph along with the aggregated value below will be displayed. Sum up all 
the values of graph and compare that against the aggregated value. Both values 
will be different.

Expected output:
What do you expect to see after performing the above steps?
Both the values (i.e. sum of all graph values and the number displayed below) 
should be same.

Actual results:
What do you actually see after performing the above steps?
Both the values (i.e. sum of all graph values and the number displayed below) 
are different.

Notes:
Provide any additional information which might be useful here. Feel free to
attach screenshots or sample code which demonstrates the issue being
described.

We have attached the screen shot herewith. The sum of all the graph values is 
112969 whereas the value displayed below graph is 97439.

Original issue reported on code.google.com by blackswa...@gmail.com on 13 Jan 2015 at 5:01

Attachments: