name: ky_day_sum
datasource: default
description: 阳性病例：总数量；管控对象数量：总数量；（每天累计汇总的数量）
label: 按日统计
options:
  parameters: []
  apply_auto_limit: false
query: |-

  {
      "collection": "ky_positive_patient_information__c",
      "aggregate": [
          {
              "$project": {
                  "is_deleted": "$is_deleted",
                  "created": {
                      "$dateToString": {
                          "format": "%Y-%m-%d %H:%M",
                          "date": "$created",
                          "timezone": "+08"
                      }
                  },
                  "created_date": {
                      "$dateToString": {
                          "format": "%Y-%m-%d",
                          "date": "$created",
                          "timezone": "+08"
                      }
                  },
                  "year": { "$year": "$created" },
                  "month": { "$month": "$created" },
                  "day": { "$dayOfMonth": "$created" }
              }
          },
          {
              "$match": {
                  "is_deleted": {
                      "$ne": true
                  }
              }
          },
          {
              "$group": {
                  "_id": "$created_date",
                  "count": {
                      "$sum": 1
                  }
              }
          },
          {
              "$project": {
                  "count": 1
              }
          }
      ]
  }