Showing negative number

[B Ashok]

Hi Team, 

My Dashboard shows a negative number. Can you please help? unfortunately, After a refresh, it's showing the correct number. 

[Mike_R]

Do you have any custom interactive filters on the dashboard? if so, that can be the culprit.

Also, can you share the report configurations?

[Community Alums]

Hi @B Ashok ,

Four types of aggregation are available for single-score reports: Count, Average, Sum, and Count Distinct. Real-time updating is available only for single score widgets that use the Count aggregation.

Note: Real-time updating does not work for single score report widgets on responsive dashboards under the following circumstances:

• When the report source is a database view, the user must click the Refresh icon  on the widget to update the score. For more information, see Database views.
• When the visualization has dot-walked conditions, the single score report does not update when there is a related change on the extended table. The record watcher only sends updates on the base table of the report. For more information, see KB article KB0868215.
• When a business rule that uses the current.update() method fires on insert/update, the single score report increments by two instead of one. For more information, see KB article KB0693812.
• When a widget uses the filter Assignment group - is (dynamic) - One of My Groups, the widget does not update in real time. For more information, see KB article KB0749987.

About this task

You can enable real-time updating for single score widgets on dashboards.

Procedure

1. Navigate to the dashboard where the single score widget has been added.
2. Click the plus sign () to put the dashboard in edit mode.
3. Point to the widget, then click the gear icon () that appears.
4. Select Show real-time updates then click Done.
5. Click the plus sign () to exit edit mode for the dashboard.
   The real-time icon () appears on the widget. This icon is permanently visible, even when the score is not changing.