*** Edited for a better way than what I originally posted (oops, still learning trellis myself) ***
Make today and yesterday their own fields for aggregation :
| eval today = if(_time >= relative_time(now(),"@d"), value,"") | eval yesterday=if(_time <=relative_time(now(),"@d"),value,"")
Add the following after your marker eval to adjust today's time backwards a day :
| eval _time=if( _time>=relative_time(now(),"@d"),relative_time(_time,"-1d"),_time)
Change your timechart to :
| timechart avg(today) as today avg(yesterday) as yesterday by db
Ensure your trellis split by is set to db
Hope it helps.
... View more