kpi
At a glance
SUM(order_details.total_refunded_tax_incl) for order_details in window (covers full state-7 and partial state-15 refunds).
| What it measures | SUM(order_details.total_refunded_tax_incl) for order_details in window (covers full state-7 and partial state-15 refunds). |
| Format | currency |
| Time window | 30D vsP |
| Alert trigger | - |
| Roles | owner, finance |
| Data type | API-derived |
Calculation
current_state in (2 Payment accepted, 3 Processing, 4 Shipped, 5 Delivered, 9 Backorder paid, 11 Remote payment accepted); shipped/fulfilled = (4, 5); refunded = (7, 15); cancelled = (6); payment error = (8). Read live from the PrestaShop Webservice API and snapshotted nightly into the Nerve Centre KPI store.