I have a dataset loaded in the below csv format
time, totalnumber, correctnumber, location
I need to do a query similar to below sql
select sum(totalnumber)- sum(correctnumber) group by time, location
Is this possible in elastic search kibana, I am currently have a scripted field Totalnumber-currentnumber and am currently displaying SUM of this in a line graph split by location and time.
But it would really help if I can display sum(totalnumber)- sum(correctnumber)