How can I show the data on the chart in View?

Looks like you are trying to create a chart on a related table. I suggest you watch the Nioxus video "500.05 - Data Visualization", along with their "400.07 - Working With Views" and perhaps their prior video on use of the "Select" statement. They are all excellent and can be found by going to youtube.com and doing a search on "Ninox Learning". The videos are long, but well worth the time, because they clearly show how to exttend Ninox way beyond simple lists and forms.

The short answer is to add a formular, like:

select members

That will give you a table, but it may not be what you want.

Try select members with Bar Chart/Columns/Stacked