Comparing Today with Yesterday [Data Table] Kibana 6.8.0

Hi,

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.

@karnamonkster

I don't think it is possible to get this in a column layout (row = device + today + yesterday tuple). And I also don't think you can specify a time-range with an offset that is not the current time (for the yesterday column).

I would file an ER https://github.com/elastic/kibana/issues/new