My solution may not be the most elegant one but this is what I did and worked for me:
index=sde sourcetype=sde_tickets State=C earliest=-13d@d latest=-7d@d CloseGroup="IS DESKTOP" | dedup Incident | timechart span=1d count(Incident) as Previous | eval Day=strftime(_time,"%a") | table Day,Previous | APPENDCOLS [ search index=sde sourcetype=sde_tickets State=C earliest=-6d@d CloseGroup="IS DESKTOP" | dedup Incident | timechart span=1d count(Incident) as Current | eval Day=strftime(_time,"%a") | table Day,Current]
... View more