Fix Incorrect Metrics Caused by Applying Filters After Aggregation

Problem: Correct Metrics Calculated Before Filtering You are maintaining a library management application with a metrics page that presents summarized values, including: Total borrowed items Total available items Total overdue items Statistics grouped by category or branch Users can narrow the displayed data with filters such as: branch category status date range Users have reported that selecting filters causes one of the values on the metrics page to become inaccurate.…