One of the aggregation query I used

DbQuery.ts

async findMany(id: string) {
    try {
      const data = await Model.aggregate([
        { $match: { businessId: new mongoose.Types.ObjectId(id) } },
        
        { $addFields: {
            dateString: { $dateToString: { format: "%Y-%m-%d", date: "$createdAt" } }
          }
        },
        
        { $sort: { createdAt: -1 } },
        
        { $group: {
            _id: {
              apiId: "$apiId",
              date: "$dateString",
              success: "$success"
            },
            firstResponse: { $first: "$$ROOT" }
          }
        },
        
        { $group: {
            _id: {
              apiId: "$_id.apiId",
              date: "$_id.date"
            },
            dayResponses: { $push: "$firstResponse" }
          }
        },
        
        { $project: {
            _id: 0,
            apiId: "$_id.apiId",
            date: "$_id.date",
            selectedResponse: {
              $cond: [
                { $eq: ["$_id.date", { $dateToString: { format: "%Y-%m-%d", date: new Date() } }] },
                { $arrayElemAt: [{ $sortArray: { input: "$dayResponses", sortBy: { createdAt: -1 } } }, 0] },
                { $arrayElemAt: [{ $sortArray: { input: "$dayResponses", sortBy: { success: 1, createdAt: -1 } } }, 0] }
              ]
            }
          }
        },
        { $sort: { date: 1 } },
        { $group: {
            _id: "$apiId",
            responses: { $push: "$selectedResponse" }
          }
        },
        { $project: {
            _id: 1,
            responses: { $slice: ["$responses", 0, 30] }
          }
        }
      ]);
      return data;
    } catch (error) {
      if(error instanceof HttpException) {
        throw error;
      }
      throw new InternalServerErrorException(error.message);
    }
  }