Difference between yesterday and one day before yesterday

I am using influx db data source and I need to make a subtraction between a sum of yesterday and a sum of one day before yesterday. do you have any idea to fix this? I tried to use variable but no success yet.

I do not know what is the problem you are trying to tell us =(

I think you want: SELECT(sum(yesterday) - sum(daybeforeyesterday))

If I am right you should do 2 sub queries, one with timestamp of yesterday and another with the other, the making the difference

But sorry, I am a little noob and I can help you writing the querie because I do not know how to parse the two times inside each queries