looking for example data per multiple end of month

[curiousfellow]

For example :

We have an invoice table with fields: amount, date_received and date_paid

In a chart I want to visualize the total amount for all invoices that are reived,but not paid per monthend

Dimension = monthend

expression = sum(amount)

So when an invoice is received in January and paid in May then I want a total for

January 31

February 28

March 31

April 30

Now I am looking for an example of a script , how to achieve this.

In real life I I have more dimensions