raw_mongo_query.json

{
    "api": "API",
    "query": [
        {
            "$match": {
                "input": "hi"
            }
        },
        {
            "$project": {
                "myTimestamp": {
                    "$dateToString": {
                        "format": "%Y-%m-%d %H:%M:%S",
                        "date": {
                            "$add": [
                                {
                                    "$toDate": "$created_at"
                                },
                                19800000
                            ]
                        },
                        "timezone": "+05:30"
                    }
                },
                "created_at": 1,
                "output": 1,
                "input2": "$input"
            }
        }
    ]
}

$match: {
      date: {
        $gte: ISODate("2023-04-16T00:00:00.000Z"),
        $lte: ISODate("2023-04-17T00:00:00.000Z")
      }
    },
{
    $group: {
      _id: "$user_id",
      count: { $sum: 1 }
    }
  }