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 month - widget will show the combined number, instead of an average.
Ps. As a workaround please filter out specific days or create custom formulas.
Please see the video below on how to create custom formula:
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.
If this does not take care of the issue, please get in touch with us via live chat and we can get to the root of the problem!