Explaining the mismatch between the widget and the persisted grid for profit per labor hour

Explaining the mismatch between the widget and the persisted grid for profit per labor hour

Anterra has built a new SM widget called 'Profit Per Labor Hour'. This widget allows users to see the profit they can make per labor hour in a specific month.


When the user clicks on the highlighted dot on the line graph (see above pic for reference), it will drill through to Work Order Profitability persisted grid.


We recognize there is a mismatch between the number on the widget and that on the grid. The mismatch is caused by some of the work orders being excluding from the persisted grid due to their accounting date keys being out of the filtered date range. Specifically, the work orders that have been closed at the end of May but their accounting dates are after May, 31st. Therefore, those work orders cannot be counted on the persisted grid. 

The below image is a query to demonstrate what the issue is.