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