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.

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.