GROUP BY LOWER(TRIM(shipping_address->>'city')) so theCairo and cairo as two separatestate when city is missing.Authorization: Bearer ********************curl --location 'https://numueg.app/api/v1/stores//analytics/sales-by-location?days=&start_date=&end_date=&granularity=&tz=' \
--header 'Authorization: Bearer <token>'{
"success": true,
"data": [
{
"location": "string",
"sales": 0,
"orders": 0,
"percentage": 0
}
],
"message": "string"
}