Group by and Sum

hello to everyone,

i currently have this kind of data imported:

invoice_number:1
service:tshirt
charge_without_vat:10.68 
invoice_amount:63.49

invoice_number:1
service:polo
charge_without_vat:5.68
invoice_amount:63.49

invoice_number:1
service:additional_service
charge_without_vat:35.10
invoice_amount:63.49

I need to group by invoice_number, sum invoice_amount and divide the result into customer base number. How can i do using a line visualization? I tried datasweet plugin but it seems not useful for the scope.

Thanks in advance!

I think you should be able to do this with either Visual Builder or Timelion.

Here's an answer to a similar question.

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