EXTRACT(dow ...)EXTRACT(hour ...); fulfillment percentiles usepercentile_cont so we don't sort a Python list of timedeltas.Authorization: Bearer ********************curl --location 'https://numueg.app/api/v1/stores//analytics/orders-breakdown?days=&start_date=&end_date=&granularity=&tz=' \
--header 'Authorization: Bearer <token>'{
"success": true,
"data": {
"by_status": [
{
"status": "string",
"count": 0,
"percentage": 0
}
],
"by_payment_method": [
{
"method": "string",
"count": 0,
"revenue": 0
}
],
"by_shipping_method": [],
"fulfillment_time": {
"avg_hours": 0,
"p50_hours": 0,
"p95_hours": 0
},
"by_day_of_week": [
{
"day": "string",
"orders": 0,
"revenue": 0
}
],
"by_hour_of_day": [
{
"hour": 0,
"orders": 0
}
]
},
"message": "string"
}