Bar Graph with Date Histogram

Hi,

I have x records in the below format.
{ customer_id: 1, paid_amount: 813, @timestamp: "2018-12-28 09:00"}
{ customer_id: 2, paid_amount: 654, @timestamp: "2018-12-28 09:00"}
{ customer_id: 1, paid_amount: 813, @timestamp: "2018-12-28 09:00"}
{ customer_id: 2, paid_amount: 654, @timestamp: "2018-12-28 09:00"}
{ customer_id: 1, paid_amount: 752, @timestamp: "2018-12-29 09:00"}
{ customer_id: 2, paid_amount: 915, @timestamp: "2018-12-29 10:00"}
{ customer_id: 1, paid_amount: 752, @timestamp: "2018-12-29 09:00"}
{ customer_id: 2, paid_amount: 915, @timestamp: "2018-12-29 10:00"}
What I would like is to show the latest total paid_amount ( **3134** ) of all the unique customer with unique paid_amount , wanted to display in bar graph for each month.
( *813 + 654 + 752+915*  =  **3134** )
Get all the unique customers and all their paid_amount values, sum only paid_amount values for a period of a month, week, and daily.

Can anyone help, please. Even if its vega or direct visualization anything is fine.

I'm thinking using ESSQL in Canvas would be your best shot for this.