I am having a heck of a time understanding how to set up a simple pie chart.
Say I have the following tables with fields
Invoices: invoice_pk, item_fk
Items: item_pk, item_type
How would I create a pie chart that showed my invoices grouped by item type (e.g., 25% were a product, 75% were a service)?