Help with a profit chart - some fields are "null"

Jason_Tran · January 19, 2024, 2:17am

(Didn’t press “Reply”)

For reference, the updated data I used (It has Revenue and Cost values of 0):

db.collection.find({},{_id:0})
[
  {
    fields: {
      'Entry Date': '2023-11-21T22:24:31.000Z',
      Cost: 0.75,
      Revenue: 0
    }
  },
  {
    fields: {
      'Entry Date': '2023-12-14T01:48:22.000Z',
      Cost: 30,
      Revenue: 1225
    }
  },
  {
    fields: {
      'Entry Date': '2023-11-06T22:40:02.000Z',
      Revenue: 1125,
      Cost: 0
    }
  }
]

For November, we can see that the total profit / loss was = (1125 - 0) + (0 - 0.75) = 1124.25
For December, we can see that the total profit / loss was = (1225 - 30) = 1195

Shown here is by month:

If we do a yearly profit loss = (1125 - 0) + (0 - 0.75) + (1225 - 30) = 2319.25

Shown here is by year:

Regards,
Jason