Skip to main content
All CollectionsChannel-specificGoogleGoogle 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 7 months 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

Did this answer your question?