All Collections
Channel-specific
Google
Google Sheets
Google Sheets - Why I don't see an average or positive/negative change showing from my Sheets?
Google Sheets - Why I don't see an average or positive/negative change showing from my Sheets?

Learn why you are not able to see an average, o positive/negative change in the reports

Daumante Kubiliunaite avatar
Written by Daumante Kubiliunaite
Updated over a week ago

Case 1: Widgets sum up values rather than showing an average?

Keep in mind that, widgets will sum up all number values for the specific day.

For example, if you have 3 different results for the 1st day of the month - the widget will show the combined number, instead of an average.

As a workaround, please filter out specific days or create custom formulas.

Case 2: Positive or negative change is not showing up.

If you’re comparing data on the sheets, for the comparison to show up, the metric's comparison for the previous period must be entered. Make sure you don't leave a separate column for it.


Wrong example

Correct example

If you have any questions or need additional help, please get in touch with our customer support via live chat or hi@whatagraph.com

Did this answer your question?