Qrew LegendMichael,
It sounds like you are doing the pie chart off the articles table. I think what Garry is suggesting is to instead do the same pie chart but do it off the journals table. We are assuming here that you have a relationship where one journal has many articles.
Ah thanks. Right now, it's set up as only one table and within the Articles table, I have an article and an journal field.
Setting up a Journals table would make sense.
The information in this e-mail is intended only for the person to whom it is addressed. If you believe this e-mail was sent to you in error and the e-mail contains patient information, please contact the Mass General Brigham Compliance HelpLine at https://www.massgeneralbrigham.org/complianceline .
Please note that this e-mail is not secure (encrypted). If you do not wish to continue communication over unencrypted e-mail, please notify the sender of this message immediately. Continuing to send or respond to e-mail after receiving this message means you understand and accept this risk and wish to continue to communicate over unencrypted e-mail.
