How to create separate Chart Views for different REF_ROWS columns related to the same table

[vitistuta]

Hello everyone,

I am working with three tables in AppSheet. Table 1 is a main database containing all the data, while Tables 2 and 3 each have a virtual column that uses the REF_ROWS formula to pull data from Table 1. The issue I’m encountering is that AppSheet seems to assign the same Chart View to both related columns, even though these columns are linked to Table 1 but refer to different columns within it.

I would like to create two separate Chart Views, one for each table, but it appears that both related columns are being treated as the same in the Chart View configuration.

How can I configure AppSheet to display the correct data in the right Chart View for each table, specifically for the columns related to Table 1?

Any help or suggestions would be greatly appreciated!