The following Splunk query will show a summary of all weekday activity for a given website in IIS.

sourcetype="iis" (NOT date_wday=saturday) (NOT date_wday=sunday)| stats count(JSESSIONID) as Value| eval Metric="Total Hits on Weekdays"| append[ search sourcetype="iis" (NOT date_wday=saturday) (NOT date_wday=sunday)| stats dc(JSESSIONID) as Value| eval Metric="Total Visits on Weekdays"]| append[ search sourcetype="iis" (NOT date_wday=saturday) (NOT date_wday=sunday) JSESSIONID=*| stats dc(JSESSIONID) as count by date_wday| stats avg(count) as Value by date_wday| eval Value=round(Value)| top limit=1 Value| eval Metric = "Average Number of Visits per day on Weekdays"]| append[ search sourcetype="iis" (NOT date_wday=saturday) (NOT date_wday=sunday) JSESSIONID=*| stats count(JSESSIONID) as count by date_wday| stats avg(count) as Value by date_wday| eval Value=round(Value)| top limit=1 Value| eval Metric = "Average Number of Hits per day on Weekdays"]| fieldformat Value=tostring(Value,"commas")| fields - count, percent| fields Metric, Value