Average date field in an aggregation

Working with Data
,
#1

Hello,

I need a little help with the aggregation framework. I want to generate a report where I am meant to get the average day over a set of matched documents in the aggregation. I have just one date field in the record to compare across all checked documents. Below is a sample document

schema = {
  _id: ObjectId('some ID'),
  created: new Date('some date'),
  ...
}
#3

Hi @Bolatan_Ibrahim,

Welcome to the MongoDB Community forums :sparkles:

To clarify, you want to generate a report where you compare each document in the collection to the average date of all the other documents in the same collection. Is that correct?

Can you please provide more information about what you are trying to achieve in your report, such as what specific date field you want to compare or what kind of result you are expecting? This will help us better understand your requirements and provide more accurate assistance.

Best,
Kushagra