I created a table with a table which records date task was created, tasks completed by departments and the availability in % of the network. I want to create a report that calculates the average availability for each department.
i created a query with fields Department from table Department total:group by, Availability from table Main total;Avg and Date from table Main total:group by and a criteria:Between [Enter Start Date] And [Enter End Date]
When i create a report based on this report i get a really long list for a report
instead i want my report to display
Dept 1 - average availability Dept 1
Dept 2 - average availability Dept 2
Dept 3 - average availability Dept 3