revenue calculation doesn't exclude past-due subscriptions in dashboard analytics

[vernu]

Description

Currently, when a subscription renewal fails, the system continues to count the failed renewal order in:

• Total revenue
• Active subscription count
• Renewed subscription revenue

Additionally, it does not properly update the Monthly Recurring Revenue (MRR) to reflect the failed payment.

Current Behavior

Failed subscription renewals are still included in revenue calculations and active subscription metrics, leading to inaccurate analytics.

Expected Behavior

• Failed renewal orders should not contribute to total revenue, active subscriptions, or renewed subscription revenue.
• Monthly Recurring Revenue (MRR) should be updated to exclude past-due subscriptions.