Similar to this Case
I am trying to display current time period (4hrs) Sum of value for a Device in one column
And yesterday's Sum of value (4hrs) for the same device in another column.
I am guessing there should be a way to use offset (-1d) to get the values for yesterday.
But need some help to achieve that.
Using the Case , i am getting an error when i put that under date histogram.