example query

example-query.js

db.collection.aggregate([
    {
        $addFields: {
            nonEmptyValues: {
                $filter: {
                    input: { $objectToArray: "$Status" },
                    as: "status",
                    cond: { $ne: ["$$status.v.value", ""] }
                }
            }
        }
    },
    {
        $addFields: {
            largestValueField: {
                $ifNull: [
                    { $arrayElemAt: [
                        { $map: {
                            input: { $slice: [{ $sortArray: { input: "$nonEmptyValues", sortBy: { "v.value": -1 } } }, 1] },
                            as: "item",
                            in: "$$item.k"
                          }
                        },
                        0
                    ]},
                    "someprefix.00.value"
                ]
            },
            nonEmptyCount: { $size: "$nonEmptyValues" },
            earliestDate: { $min: "$nonEmptyValues.v.date" }
        }
    },
    {
        $sort: {
            nonEmptyCount: 1,
            earliestDate: 1
        }
    }
]);