FGdb Reports

Trend Reports
(These show trends over time)

Volunteer Related

 * Numbers of volunteers volunteering over time.
 * filter on program (adoption, build, other)
 * filter on job (receiving, recycling, data entry)
 * Same thing, but total of hours volunteered instead of volunteer count.
 * Number of active volunteers over time (an active volunteer has logged >= 4 hrs in the last 90 days.) DONE
 * hours by task category/program (does that exist yet?) OR distinct person count by task category/program over date range grouped by date

Gizmo Related

 * Numbers of (gizmo_types) received over time.
 * Numbers of (gizmo_types) sold over time.
 * Numbers of (gizmo_types) disbursed over time.
 * Same as above but for (gizmo_categories) instead of (gizmo_types).
 * Same as the above (gizmo_types) but be able to pick >1 type, so you can see (for example) the relation between laptops and systems received, sold, whatever.
 * gizmos by type or category flow type (incoming or outgoing) over date range grouped by date, week, month, quarter, or year

Income

 * Average donations, fees, and total (i.e. front desk income) over time (DONE, pretty much).
 * Average amount of sale over time. (Be able to select a (gizmo_type) or (gizmo_types) for comparison. OR Be able to look at all sales, regardless of (gizmo_type).)
 * over date range grouped by day, week, month, or year donation income by fee and contribution sale income by discount type and totals

Other

 * - # systems, monitors, printers granted
 * - # systems, monitors, printers adopted
 * - # systems, monitors, printers sold
 * - # systems, monitors, printers recycled
 * - % of systems, monitors, and printers granted, adopted, sold, and recycled
 * * extra swanky: these numbers (or at least the non-recycle numbers) for laptops, macs


 * - # new volunteers in build, adoption, other
 * - # volunteers who logged hours in build, adoption, other
 * - # hours logged in build, adoption,


 * - # donations
 * - # unique donors
 * - avg. amount of money given per donation


 * - # sales
 * - # unique store customers
 * - avg. amount spent per store transaction


 * Total sales ($) by gizmo_type (and gizmo_category) over a period of time. (This is a trends or "over time" type report.)
 * Same as above, but limit to discount type -- that is I want to see trends on systems that were sold at a volunteer discount.

Would need additional changes to database

 * Recycling tonnage: How many tons of e-waste did we recycle last year?
 * Collection events: "I helped organize 3 collection events (Hillsboro Library, Elementary School, and ECOHAUS) in 2008, how many others were there? For instance, I know that Hasson Realtors partnered with Free Geek on one."

Don't need additional changes

 * How many folks volunteered at Free Geek in 2008?
 * How many hours total did they collectively volunteer?

Not sure

 * We donated approx. 1200 computers last year - how many were given to adoptees & how many to grantees?
 * Do we keep track of numbers of equipment/gizmos processed for 2008: computers, printers, keyboards, etc.
 * A list of organizations that received Free Geek computers in 2008.
 * A list of all Free Geek cash donors and amounts for 2008-I've got the spreadsheet for the Give Guide donors. Can you combine the Causes and all others into one e-report? This would also include in kind donations from Companies/individuals. I would like to exclude the front desk donations unless they were notable amounts - $50+

Other
Some reports mentioned that are not trend report ("over time"):
 * List all volunteers that have worked (more than | less than | between) a certain number of hours.
 * List all organizations that have donated gizmos in a given date range that (are | are not) covered entities.