You are using a pivot table in your canvas report but the report does NOT...

Issue with Static Date Filters:

If the query uses a static date filter (e.g., a specific range like "January 1, 2023, to March 31, 2023"), the report will not reflect the most recent data as the filter restricts results to the defined date range.

Resolution:

Update the query to use dynamic date filters (e.g., "Last 30 Days" or "Current Year") to ensure the pivot table includes the latest data.