Query

Example request

{
  "limit": 100000,
  "where": {
    "operator": "AND",
    "rules": [
      {
        "field": "dt",
        "condition": ">=",
        "data": "2024-02-21 00:00:00"
      },
      {
        "field": "dt",
        "condition": "<",
        "data": "2024-02-21 23:59:59"
      }
    ]
  },
  "group": [
    "customer_id",
    "provider_id",
    "customer_card_dest_name",
    "provider_card_dest_name"
  ],
  "field": [
    "customer_id",
    "provider_id",
    "customer_card_dest_name",
    "provider_card_dest_name",
    {
      "field": "attempts",
      "fn": "sum"
    },
    {
      "field": "connected",
      "fn": "sum"
    },
    {
      "field": "sdp_6",
      "fn": "sum"
    },
    {
      "field": "customer_duration",
      "fn": "sum"
    },
    {
      "field": "provider_duration",
      "fn": "sum"
    },
    {
      "field": "duration",
      "fn": "sum"
    },
    {
      "field": "provider_charge",
      "fn": "sum"
    },
    {
      "field": "customer_charge",
      "fn": "sum"
    },
    {
      "field": "customer_charge_avg",
      "fn": "avg"
    },
    {
      "field": "provider_charge_avg",
      "fn": "avg"
    },
    {
      "field": "provider_currency",
      "fn": "first"
    },
    {
      "field": "customer_currency",
      "fn": "first"
    },
    {
      "fn": "asr"
    },
    {
      "fn": "acd"
    },
    {
      "fn": "dtmf"
    },
    {
      "field": "account_profit",
      "fn": "sum"
    },
    {
      "field": "account_profit_percent",
      "fn": "avg"
    }
  ]
}