Discoverer: Average workbook runs by week day

This chart shows which is the peak day for workbook usage.

select week_day||'-'||run_day Day, 'Average Runs',trunc(sum(runs)/count(run_day)) average_runs
from
(
select run_month,week_day,run_day,month_day,run_year,count(*) runs
from
(
select qs_cost cost
, qs_act_cpu_time cpu_time
, qs_act_elap_time elapsed_time
, qs_num_rows rows_fetched
, qs_doc_owner doc_owner
, qs_doc_name workbook
, qs_doc_details worksheet
, qs_created_date run_date
, to_char(qs_created_date,'D') week_day
, to_char(qs_created_date,'DD') month_day
, to_char(qs_created_date,'Day') run_day
, to_char(qs_created_date,'Mon') run_month
, to_char(qs_created_date,'HH24') run_hour
, to_char(qs_created_date,'YYYY') run_year
from eul5_qpp_stats
where qs_created_date between sysdate - 7 and sysdate
) stats
group by run_month,week_day,run_day,month_day,run_year
)
group by run_day,week_day
order by week_day