just like ur concept but change the parameter into date_wday, my search as follow:
index= | timechart count(date_wday) as count span=1w|join _time [search index=dynadvisor | timechart dc(date_wday) as day_num span=1w]|eval avg=count/day_num
hop it helpful
... View more