# Orders

The orders report aggregates payment attempts by the order identifier (`order_id`) and computes the final status from the last attempt recorded within the queried period.

## Inclusion criteria

- Only orders whose **first attempt** occurred within the filter period are considered.
- Only attempts **within the period** are used to determine the final status.
- Orders without `order_id` are ignored.

## Example

Consider the payments below:

| Date       | Payment | Order | Attempt | Status   |
|------------|---------|-------|---------|----------|
| 03/25/2024 | 1       | 1000  | 1st     | Declined |
| 04/01/2024 | 2       | 1000  | 2nd     | Approved |
| 04/05/2024 | 3       | 1001  | 1st     | Approved |
| 04/10/2024 | 4       | 1002  | 1st     | Declined |
| 04/11/2024 | 5       | 1002  | 2nd     | Declined |
| 04/13/2024 | 6       | 1002  | 3rd     | Approved |
| 04/13/2024 | 7       | 1003  | 1st     | Declined |
| 04/28/2024 | 8       | 1004  | 1st     | Declined |
| 05/01/2024 | 9       | 1004  | 2nd     | Approved |

With a period filter between 04/01/2024 and 04/30/2024, the report shows:

- Approved: 2 orders
- Declined: 2 orders
- Total: 4 orders

Breakdown:

- **Order 1000:** disregarded — first attempt outside the period.
- **Order 1001:** approved — single attempt, within the period.
- **Order 1002:** approved — first attempt in the period and an approved retry also in the period.
- **Order 1003:** declined — single attempt, within the period.
- **Order 1004:** declined — first attempt in the period; the approved retry occurred after the end of the period.