I have a table called coverage and another one called coverageReport
In the table coverage the user can enter lots of data but for the purposes of this they enter date and region (coverage::date and coverage::region)
the two tables are linked by date so coverage report has a start date and an end date and they are linked when coverage::date is between coverageReport::startdate and CoverageReport::Enddate.
coverage::region is a drop down box with 7 possible entries. for the porposes of this lets say A,B,C,D,E,F,G
I would like to do a piechart in coverageReport for coverage::region
How can I do this?