for our position management dashboard we cout our positions by date everyday.
today in production while we try to count as of 11/04/2025 the dashboard shows no data.
this type of query is working for the previous dates like 10/04 or 09/04.