What is formula for "Orders Are Late"?

Hi,
I am developer & my client wanted a few reports.
Once of them., there is one dataset like “Orders Are Late” on dashboard. Pic attached.
I need that kind of data for date wise in our custom report. How can I get that data? Should I consider
unfulfilled as late order for that date ?

Hello @sannket!

The field that contains that value is required_ship_date inside the order or orders queries.

here’s an example:

query {
  orders {
    request_id
    complexity
    data(first: 10) {
      edges {
        node {
          legacy_id
          order_number
          partner_order_id
          required_ship_date
        }
      }
    }
  }
}

To find what other fields you can use with those queries, please check our schema.

Have a nice day!
TomasFD