---
title: "Query date_breakdown on orders"
method: POST
path: "/orders/date_breakdown"
tags: ["orders"]
---

# Query date_breakdown on orders

`POST /orders/date_breakdown`

Date breakdowns summarizes metrics data grouped by time intervals on a defined time range. They also support support breakdowns over the main date breakdown query and also supports all breakdown queries capabilities through the "breakdown" key, this also includes the possibility of nesting the breakdown over the main breakdown. 


Single date breakdown request (no breakdown)

`{
	"date_breakdown": {
            "by": "shipments.cancelled_at",
            "field": "order.id",
            "interval": "month",
            "operator": "value_count"
        }
}`
  
  
Single date breakdown request with one breakdown
 
` 
{
	"date_breakdown": {
            "by": "shipments.cancelled_at",
            "field": "order.id",
            "interval": "month",
            "operator": "value_count",
            "breakdown": {
                "by": "order.currency_code",
                "field": "order.total_amount_with_taxes",
                "operator": "sum",
                "sort": "desc",
                "limit": 5
            }
        }
  }`
  
  
Single date breakdown request with breakdown with a nested breakdown

` 
{
"date_breakdown": {
        "by": "order.placed_at",
        "field": "order.total_amount_with_taxes",
        "operator": "stats",
        "interval": "month",
        "breakdown": {
            "by": "order.country_code",
            "field": "line_items.total_amount",
            "operator": "sum",
            "sort": "desc",
            "limit": 20,
            "breakdown": {
                "by": "order.currency_code",
                "field": "line_items.total_amount",
                "operator": "sum",
                "sort": "desc",
                "limit": 21
            }
        }
    }
 }`

## Response `200`

The date_breakdown result from orders

---

[API](https://skmtc.dev/commercelayer/apis/commerce-layer-metrics-api.md) · [All operations](https://skmtc.dev/commercelayer/apis/commerce-layer-metrics-api/llms.txt) · [OpenAPI document](https://skmtc-service-production.skmtc.workers.dev/v1/apis/commercelayer/commerce-layer-metrics-api/revisions/01043d675bc3/schema)