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.