Can I Sum the records, for a period let's say for the last 6 months only?

[kumaresan]

Let say,
totalRevenue = entity\sumRelated('opportunities', 'amount', 'won'); only from last 6 months

Help me with FILTER for a period for sum and count

[esforim]

Hi kuma,

Unfortunately no! Not easily as least, will need to do coding.

As far as I'm aware of it. Recently I made a post asking a similar question of doing it by date/period but the answer is basically no from one other user. Perhaps it is possible but it not being shared publicly.

See it here: https://forum.espocrm.com/forum/gene...-pay-timesheet