I want to create a chart using values from array columns

I’m creating a recruitment app for candidates, clients and vacancies. For each client, I’d like a chart displayed which is a count for each candidate submitted to a particular vacancy.

I can create three separate rows for each candidate submission in the vacancy tab, but I only want to see one vacancy row but have “Candidate 1”, “Candidate 2”, etc. Represent the CV Submissions on the client record in the client tabs.

Is there a way you could create a chart that will count and match each entity in a group of array columns?