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 4 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?