# I want to create a chart using values from array columns

**URL:** <https://community.glideapps.com/t/i-want-to-create-a-chart-using-values-from-array-columns/28584>\
**Category:** Ask for Help\
**Created:** [July 1, 2021, 7:04pm UTC](https://community.glideapps.com/t/i-want-to-create-a-chart-using-values-from-array-columns/28584 "2021-07-01T19:04:26Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![CJvdW](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/cjvdw/32/16768_2.png) [@CJvdW](https://community.glideapps.com/u/CJvdW)\
**Post date:** [July 1, 2021, 7:04pm UTC](https://community.glideapps.com/t/i-want-to-create-a-chart-using-values-from-array-columns/28584/1 "2021-07-01T19:04:27Z")

</div>

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?