Group data by dates in mongodb without extract all the values.

mongodb_group.js

import mongoose from "mongoose";

import dotenv from "dotenv";
dotenv.config();

mongoose
  .connect(process.env.MONGO_SOURCE)
  .then(async () => {
    console.log("connected");

    let db = mongoose.connection.db;

    const data = await db
      .collection("cyball_guild_leaderboards")
      .aggregate([
        {
          $group: {
            _id: { $dateToString: { format: "%Y-%m-%d", date: "$createdAt" } },
            list: { $push: "$$ROOT" },
            count: { $sum: 1 },
          },
        },
      ])
      .toArray();

    console.log(data);
  })
  .then(() => {
    console.log("process successful");
  })
  .catch((e) => {
    console.log("process failed:", e.message);
  })
  .then(() => {
    console.log("disconnecting");
    mongoose.disconnect();
  });