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